APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 461: select pay_assignment_actions_s.nextval

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

Line 1418: from pay_assignment_actions paa,

1414: cursor csr_copy_assact
1415: is
1416: select /*+ ORDERED */
1417: assact.assignment_action_id
1418: from pay_assignment_actions paa,
1419: pay_jp_isdf_assact_v assact
1420: where paa.payroll_action_id = g_copy_archive_pact_id
1421: and paa.assignment_id = p_assignment_id
1422: and paa.action_status = 'C'

Line 2421: from pay_assignment_actions

2417: end if;
2418: --
2419: select assignment_id
2420: into l_assignment_id
2421: from pay_assignment_actions
2422: where assignment_action_id = p_assignment_action_id;
2423: --
2424: if g_debug then
2425: hr_utility.set_location(l_proc,10);