APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 98: from pay_assignment_actions paa,

94: cursor csr_classification
95: is
96: select /*+ ORDERED */
97: pec.classification_name
98: from pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_run_results prr,
101: pay_element_types_f pet,
102: pay_element_classifications pec

Line 1250: select pay_assignment_actions_s.nextval

1246: and g_detail_debug = 'Y' then
1247: l_assact_step := 28;
1248: end if;
1249: --
1250: select pay_assignment_actions_s.nextval
1251: into l_assignment_action_id
1252: from dual;
1253: --
1254: if g_debug

Line 1559: from pay_assignment_actions paa,

1555: is
1556: select /*+ ORDERED */
1557: paa.assignment_action_id,
1558: ppa.effective_date
1559: from pay_assignment_actions paa,
1560: pay_payroll_actions ppa
1561: where paa.assignment_id = p_assignment_id
1562: and paa.action_status = 'C'
1563: and ppa.payroll_action_id = paa.payroll_action_id

Line 1572: pay_assignment_actions paa_v,

1568: and not exists(
1569: select /*+ ORDERED */
1570: null
1571: from pay_action_interlocks pai_v,
1572: pay_assignment_actions paa_v,
1573: pay_payroll_actions ppa_v
1574: where pai_v.locked_action_id = paa.assignment_action_id
1575: and paa_v.assignment_action_id = pai_v.locking_action_id
1576: and ppa_v.payroll_action_id = paa.payroll_action_id

Line 2486: from pay_assignment_actions

2482: end if;
2483: --
2484: select assignment_id
2485: into l_assignment_id
2486: from pay_assignment_actions
2487: where assignment_action_id = p_assignment_action_id;
2488: --
2489: if g_debug then
2490: hr_utility.set_location(l_proc,10);