APPS.PAY_CA_T4_CANCEL_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 13: pay_payroll_actions ppa,

9: ppa.payroll_action_id,
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

Line 36: pay_payroll_actions ppa,

32: to_char(max(ppa1.payroll_action_id))
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,

Line 38: pay_payroll_actions ppa1,

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
42: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 76: pay_payroll_actions ppa,

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
80: AND pai.locking_action_id = paa.assignment_action_id