APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 627: pay_assignment_actions paa,

623: select prrv.result_value
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'

Line 649: pay_assignment_actions paa,

645: select prrv.result_value
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'

Line 1957: from pay_assignment_actions paa,

1953: ppp.pre_payment_id,
1954: popm.org_payment_method_id,
1955: popm.org_payment_method_name,
1956: pppm.personal_payment_method_id
1957: from pay_assignment_actions paa,
1958: pay_pre_payments ppp,
1959: pay_org_payment_methods_f popm ,
1960: pay_personal_payment_methods_f pppm,
1961: pay_external_accounts pea

Line 1977: pay_assignment_actions paa_run,

1973: and cp_ppp_source_action_id is null
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

Line 2120: from pay_assignment_actions paa

2116:
2117: cursor c_child_action (cp_pre_pay_action_id in number
2118: ,cp_assignment_id in number) is
2119: select paa.assignment_action_id
2120: from pay_assignment_actions paa
2121: where paa.source_action_id = cp_pre_pay_action_id
2122: and paa.assignment_id = cp_assignment_id
2123: and paa.action_status = 'C';
2124:

Line 2145: from pay_assignment_actions paa,

2141: ppp.pre_payment_id,
2142: popm.org_payment_method_id,
2143: popm.org_payment_method_name,
2144: pppm.personal_payment_method_id
2145: from pay_assignment_actions paa,
2146: pay_pre_payments ppp,
2147: pay_org_payment_methods_f popm ,
2148: pay_personal_payment_methods_f pppm,
2149: pay_external_accounts pea

Line 2165: pay_assignment_actions paa_run,

2161: and cp_ppp_source_action_id is null
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

Line 2706: ,pay_assignment_actions paa

2702: select distinct
2703: nvl(pai.tax_unit_id, -1)
2704: ,pai.action_information2 organization_id
2705: from pay_action_information pai
2706: ,pay_assignment_actions paa
2707: where pai.action_information_category = 'EMPLOYEE DETAILS'
2708: and pai.action_context_type = 'AAP'
2709: and pai.action_context_id = paa.assignment_action_id
2710: and paa.payroll_Action_id = cp_payroll_action_id