DBA Data[Home] [Help]

APPS.PAY_CA_T4_AMEND_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 48: pay_assignment_actions aa,

44: FROM
45: ff_archive_items fai,
46: ff_database_items fdi,
47: pay_payroll_actions ppa,
48: pay_assignment_actions aa,
49: hr_organization_information hoi1,
50: hr_organization_information hoi2,
51: pay_ca_legislation_info pcli2
52: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 97: pay_assignment_actions paa,

93: FROM
94: per_all_people_f ppf,
95: per_all_assignments_f paf,
96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch,
100: pay_payroll_actions ppa_arch
101: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 99: pay_assignment_actions paa_arch,

95: per_all_assignments_f paf,
96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch,
100: pay_payroll_actions ppa_arch
101: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
102: AND paa.payroll_action_id = ppa.payroll_action_id
103: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')