APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 457: select pay_assignment_actions_s.nextval

453: hr_utility.set_location(l_proc,80);
454: hr_utility.trace('assignment_id : '||l_assignment_id);
455: end if;
456: --
457: select pay_assignment_actions_s.nextval
458: into l_assignment_action_id
459: from dual;
460: --
461: hr_nonrun_asact.insact(

Line 1316: from pay_assignment_actions paa,

1312: cursor csr_copy_assact
1313: is
1314: select /*+ ORDERED */
1315: assact.assignment_action_id
1316: from pay_assignment_actions paa,
1317: pay_jp_isdf_assact_v assact
1318: where paa.payroll_action_id = g_copy_archive_pact_id
1319: and paa.assignment_id = p_assignment_id
1320: and paa.action_status = 'C'

Line 2177: from pay_assignment_actions

2173: end if;
2174: --
2175: select assignment_id
2176: into l_assignment_id
2177: from pay_assignment_actions
2178: where assignment_action_id = p_assignment_action_id;
2179: --
2180: if g_debug then
2181: hr_utility.set_location(l_proc,10);