SELECT 'Z20' TYPE_OF_ROW
,jesr.authority_type PARTY_QUALIFIER
,jesr.account_number ACCOUNT_NUMBER
,to_char(round(sum(nvl(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT
,jesr.natural_account NATURAL_ACCOUNT
,jesr.segment_desc ACCOUNT_DESCRIPTION
FROM je_no_gei_sreport_v jesr
WHERE (:P_PERIOD_NUM > 12 and jesr.period_num = :P_PERIOD_NUM)
AND jesr.period_year = :P_PERIOD_YEAR
AND nvl(jesr.balance,0) <> 0
AND jesr.template_id = :P_TEMPLATE_ID
AND jesr.actual_flag = 'A'
GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc
having round(sum(nvl(jesr.balance,0)), :P_PRECISION) <>0
UNION
SELECT 'Z20' TYPE_OF_ROW
,jesr.authority_type PARTY_QUALIFIER
,jesr.account_number ACCOUNT_NUMBER
,TO_CHAR(ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION), 'S99999999999999999D00') AMOUNT
,jesr.natural_account NATURAL_ACCOUNT
,jesr.segment_desc ACCOUNT_DESCRIPTION
FROM je_no_gei_sreport_v jesr
WHERE (:P_PERIOD_NUM <= 12 AND jesr.period_num <= :P_PERIOD_NUM)
AND jesr.period_year = :P_PERIOD_YEAR
AND nvl(jesr.balance,0) <> 0
AND jesr.template_id = :P_TEMPLATE_ID
AND jesr.actual_flag = 'A'
GROUP BY jesr.authority_type, jesr.account_number, jesr.natural_account, jesr.segment_desc
having ROUND(SUM(NVL(jesr.balance,0)), :P_PRECISION) <>0 |