[Home] [Help]
91: p.period_name,
92: rpad(''x'',500) pad
93: FROM xla_tb_defn_details d,
94: xla_tb_definitions_vl vl,
95: gl_period_statuses p
96: WHERE d.definition_code = ''$p_definition_code$''
97: AND vl.definition_code = d.definition_code
98: AND p.application_id =200
99: AND p.ledger_id = vl.ledger_id
203: sum(nvl(l.accounted_cr, 0))- sum(nvl(l.accounted_dr,0)) NONAP_AMOUNT
204: FROM gl_je_headers h
205: ,gl_je_lines l
206: ,xtd
207: ,gl_period_statuses p
208: WHERE l.code_combination_id = xtd.code_combination_id
209: AND l.ledger_id = xtd.ledger_id
210: AND l.period_name = p.period_name
211: AND h.je_source <> ''Payables''
1250:
1251:
1252: CURSOR c_max_open_period IS
1253: SELECT period_name
1254: FROM gl_period_statuses
1255: WHERE application_id =101
1256: AND ledger_id = p_ledger_id
1257: AND NVL(adjustment_period_flag,'N')='N'
1258: AND closing_status = 'O'
1258: AND closing_status = 'O'
1259: AND effective_period_num =
1260: (
1261: SELECT max(effective_period_num)
1262: FROM gl_period_statuses
1263: WHERE application_id = 101
1264: AND ledger_id = p_ledger_id
1265: AND NVL(adjustment_period_flag,'N')='N'
1266: AND closing_status = 'O'
1330: To avoid gl_balance being shown 0 in such cases following logic is followed:
1331: a. Check whether the period exists in gl_balance for as_of_date entered
1332: b. If not in the Exceptions block get the latest open period and start date
1333: IF latest open period is NULL then its an adjustment period...
1334: Obtain the actual period_name for the latest open period in gl_period_statuses
1335: for the ledger and return.
1336: ELSIF as_of_date entered is < than start_date of latest open period
1337: Return Null ( example as_of_date entered is a prior period like '01-JAN-1930'
1338: ELSE