APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 628: pay_payroll_actions ppa

624: from pay_run_results prr,
625: pay_run_result_values prrv,
626: pay_input_values_f piv,
627: pay_assignment_actions paa,
628: pay_payroll_actions ppa
629: where prr.element_type_id + 0 = piv.element_type_id
630: and prr.run_result_id = prrv.run_result_id
631: and prr.source_type = 'E'
632: and piv.input_value_id = prrv.input_value_id

Line 650: pay_payroll_actions ppa

646: from pay_run_results prr,
647: pay_run_result_values prrv,
648: pay_input_values_f piv,
649: pay_assignment_actions paa,
650: pay_payroll_actions ppa
651: where prr.element_type_id + 0 = piv.element_type_id
652: and prr.run_result_id = prrv.run_result_id
653: and prr.source_type = 'E'
654: and piv.input_value_id = prrv.input_value_id

Line 1978: pay_payroll_actions ppa_run

1974: and exists (
1975: select ''
1976: from pay_run_types_f prt,
1977: pay_assignment_actions paa_run,
1978: pay_payroll_actions ppa_run
1979: where paa_run.assignment_action_id
1980: = ppp.source_action_id
1981: and paa_run.payroll_action_id
1982: = ppa_run.payroll_action_id

Line 2166: pay_payroll_actions ppa_run

2162: and exists (
2163: select ''
2164: from pay_run_types_f prt,
2165: pay_assignment_actions paa_run,
2166: pay_payroll_actions ppa_run
2167: where paa_run.assignment_action_id
2168: = ppp.source_action_id
2169: and paa_run.payroll_action_id
2170: = ppa_run.payroll_action_id

Line 2715: from pay_payroll_actions ppa

2711: and paa.action_status = 'C';
2712:
2713: cursor c_bg (cp_payroll_action_id in number) is
2714: select ppa.business_group_id
2715: from pay_payroll_actions ppa
2716: where ppa.payroll_action_id = cp_payroll_action_id;
2717:
2718: ln_business_group_id NUMBER;
2719: ln_organization_id NUMBER;