[Home] [Help]
180: if g_program_name = 'RB_ADJD' then
181: select defined_balance_id,
182: balance_load_date,
183: run_balance_status,
184: case when run_balance_status = 'V' and balance_load_date <= g_start_date then g_start_date else hr_api.g_eot end del_bal_before,
185: case when run_balance_status = 'V' and balance_load_date <= g_start_date then 'Y' else 'N' end purge_only
186: bulk collect into g_old_balance_validation_tab
187: from pay_balance_validation
188: where business_group_id = l_bus_grp;
204: ) then
205: --
206: if (g_load_type <> 'DELTA') then
207: --
208: select nvl(pbv.run_balance_status, 'I'), nvl(pbv.balance_load_date,hr_api.g_eot)
209: into l_run_bal_stat, l_old_balance_load_date
210: from pay_defined_balances pdb,
211: pay_balance_validation pbv
212: where pdb.defined_balance_id = dbrec.defined_balance_id
247: /* Single Balance load */
248: --
249: if (g_load_type <> 'DELTA') then
250: --
251: select nvl(pbv.run_balance_status, 'I'), nvl(pbv.balance_load_date,hr_api.g_eot)
252:
253: into l_run_bal_stat, l_old_balance_load_date
254: from pay_defined_balances pdb,
255: pay_balance_validation pbv
1889: if g_program_name = 'RB_ADJD' then --{ RB_ADJD
1890: select defined_balance_id,
1891: balance_load_date,
1892: run_balance_status,
1893: case when balance_status is null then g_start_date else hr_api.g_eot end del_bal_before,
1894: case when balance_status is null then 'Y' else 'N' end purge_only
1895: bulk collect into g_old_balance_validation_tab
1896: from ( select bv.defined_balance_id,
1897: bv.balance_load_date, run_balance_status, bv.business_group_id,