DBA Data[Home] [Help]

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 33: pay_action_interlocks int,

29: pay_payroll_actions ppa,
30: pay_payroll_actions ppa1,
31: pay_assignment_actions paa,
32: pay_assignment_actions paa1,
33: pay_action_interlocks int,
34: hr_organization_information hoi
35: WHERE
36: ppa.payroll_action_id = paa.payroll_action_id
37: AND hoi.org_information_context = 'Fed Magnetic Reporting'

Line 64: pay_action_interlocks int,

60: pay_payroll_actions ppa,
61: pay_assignment_actions paa,
62: pay_payroll_actions ppa1,
63: pay_assignment_actions paa1,
64: pay_action_interlocks int,
65: hr_organization_information hoi1
66: WHERE paa.payroll_action_id = ppa.payroll_action_id
67: AND hoi1.organization_id = paa1.tax_unit_id
68: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

Line 99: pay_action_interlocks pai,

95: paa.assignment_action_id
96: FROM
97: per_all_people_f ppf,
98: per_all_assignments_f paf,
99: pay_action_interlocks pai,
100: pay_assignment_actions paa,
101: pay_payroll_actions ppa,
102: pay_assignment_actions paa_mag
103: WHERE