APPS.PAY_CA_T4_CANCEL_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 14: pay_assignment_actions paa,

10: 'TRANSMITTER_GRE_ID=P',
11: to_char(hoi.organization_id)
12: FROM
13: pay_payroll_actions ppa,
14: pay_assignment_actions paa,
15: hr_organization_information hoi
16: WHERE
17: ppa.payroll_action_id = paa.payroll_action_id
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'

Line 37: pay_assignment_actions paa,

33: FROM
34: ff_archive_items fai,
35: ff_database_items fdi,
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

Line 39: pay_assignment_actions paa1,

35: ff_database_items fdi,
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

Line 75: pay_assignment_actions paa,

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'))
79: AND paa.payroll_action_id = ppa.payroll_action_id

Line 77: pay_assignment_actions paa_mag

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'))
79: AND paa.payroll_action_id = ppa.payroll_action_id
80: AND pai.locking_action_id = paa.assignment_action_id
81: AND paf.assignment_id = paa.assignment_id