DBA Data[Home] [Help]

APPS.PAY_CA_T4_CANCEL_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 40: pay_action_interlocks int,

36: pay_payroll_actions ppa,
37: pay_assignment_actions paa,
38: pay_payroll_actions ppa1,
39: pay_assignment_actions paa1,
40: pay_action_interlocks int,
41: hr_organization_information hoi1
42: WHERE paa.payroll_action_id = ppa.payroll_action_id
43: AND hoi1.organization_id = paa1.tax_unit_id
44: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

Line 74: pay_action_interlocks pai,

70: paa.assignment_action_id
71: FROM
72: per_all_people_f ppf,
73: per_all_assignments_f paf,
74: pay_action_interlocks pai,
75: pay_assignment_actions paa,
76: pay_payroll_actions ppa,
77: pay_assignment_actions paa_mag
78: WHERE ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))