APPS.PAY_CA_T4A_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 29: pay_payroll_actions ppa,

25: ppa1.payroll_action_id,
26: 'TRANSMITTER_GRE_ID=P',
27: to_char(hoi.organization_id)
28: FROM
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,

Line 30: pay_payroll_actions ppa1,

26: 'TRANSMITTER_GRE_ID=P',
27: to_char(hoi.organization_id)
28: FROM
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

Line 60: pay_payroll_actions ppa,

56: to_char(max(ppa1.payroll_action_id))
57: FROM
58: ff_archive_items fai,
59: ff_database_items fdi,
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,

Line 62: pay_payroll_actions ppa1,

58: ff_archive_items fai,
59: ff_database_items fdi,
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

Line 101: pay_payroll_actions ppa,

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
104: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
105: AND paa.payroll_action_id = ppa.payroll_action_id