APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_PAYROLL_ACTIONS

Line 589: pay_payroll_actions ppa

585: from pay_run_results prr,
586: pay_run_result_values prrv,
587: pay_input_values_f piv,
588: pay_assignment_actions paa,
589: pay_payroll_actions ppa
590: where prr.element_type_id + 0 = piv.element_type_id
591: and prr.run_result_id = prrv.run_result_id
592: and prr.source_type = 'E'
593: and piv.input_value_id = prrv.input_value_id

Line 611: pay_payroll_actions ppa

607: from pay_run_results prr,
608: pay_run_result_values prrv,
609: pay_input_values_f piv,
610: pay_assignment_actions paa,
611: pay_payroll_actions ppa
612: where prr.element_type_id + 0 = piv.element_type_id
613: and prr.run_result_id = prrv.run_result_id
614: and prr.source_type = 'E'
615: and piv.input_value_id = prrv.input_value_id

Line 1883: pay_payroll_actions ppa_run

1879: and exists (
1880: select ''
1881: from pay_run_types_f prt,
1882: pay_assignment_actions paa_run,
1883: pay_payroll_actions ppa_run
1884: where paa_run.assignment_action_id
1885: = ppp.source_action_id
1886: and paa_run.payroll_action_id
1887: = ppa_run.payroll_action_id

Line 2071: pay_payroll_actions ppa_run

2067: and exists (
2068: select ''
2069: from pay_run_types_f prt,
2070: pay_assignment_actions paa_run,
2071: pay_payroll_actions ppa_run
2072: where paa_run.assignment_action_id
2073: = ppp.source_action_id
2074: and paa_run.payroll_action_id
2075: = ppa_run.payroll_action_id

Line 2612: from pay_payroll_actions ppa

2608: and paa.action_status = 'C';
2609:
2610: cursor c_bg (cp_payroll_action_id in number) is
2611: select ppa.business_group_id
2612: from pay_payroll_actions ppa
2613: where ppa.payroll_action_id = cp_payroll_action_id;
2614:
2615: ln_business_group_id NUMBER;
2616: ln_organization_id NUMBER;