DBA Data[Home] [Help]

APPS.PAY_CA_T4A_AMEND_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 43: pay_assignment_actions aa,

39: FROM
40: ff_archive_items fai,
41: ff_database_items fdi,
42: pay_payroll_actions ppa,
43: pay_assignment_actions aa,
44: hr_organization_information hoi1,
45: hr_organization_information hoi2
46: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
47: AND hoi1.org_information11 = aa.tax_unit_id

Line 87: pay_assignment_actions paa,

83: FROM
84: per_all_people_f ppf,
85: per_all_assignments_f paf,
86: pay_action_interlocks pai,
87: pay_assignment_actions paa,
88: pay_payroll_actions ppa,
89: pay_assignment_actions paa_arch,
90: pay_payroll_actions ppa_arch
91: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 89: pay_assignment_actions paa_arch,

85: per_all_assignments_f paf,
86: pay_action_interlocks pai,
87: pay_assignment_actions paa,
88: pay_payroll_actions ppa,
89: pay_assignment_actions paa_arch,
90: pay_payroll_actions ppa_arch
91: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
92: AND paa.payroll_action_id = ppa.payroll_action_id
93: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')