DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on DUAL

Line 444: FROM dual;

440: FOR csr_rec IN c_process_assignments
441: LOOP
442: SELECT pay_assignment_actions_s.NEXTVAL
443: INTO l_action_id
444: FROM dual;
445:
446: if g_debug then
447: pay_in_utils.trace('l_action_id : ',l_action_id);
448: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

Line 2020: -- Step 5 - Get individual perquisite values

2016: l_others_proj := g_balance_value_tab(3).balance_value ;
2017:
2018: pay_in_utils.set_location(g_debug,'Furniture and Total Perquisites '||l_proc,40);
2019:
2020: -- Step 5 - Get individual perquisite values
2021: g_balance_value_tab.DELETE;
2022: g_context_table.DELETE;
2023: g_result_table1.delete;
2024: g_result_table2.DELETE;