APPS.PAY_CA_RL2_CAN_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 27: pay_payroll_actions ppa

23: SELECT distinct
24: 'PAYROLL_ACTION_ID=P',
25: ppa.payroll_action_id
26: from
27: pay_payroll_actions ppa
28: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'));
29: /* SELECT distinct
30: 'PAYROLL_ACTION_ID=P',
31: ppa1.payroll_action_id,

Line 35: pay_payroll_actions ppa,

31: ppa1.payroll_action_id,
32: 'PAYROLL_ACTION_ID=C',
33: ppa1.payroll_action_id
34: from
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1,
37: pay_assignment_actions paa,
38: pay_assignment_actions paa1,
39: pay_action_interlocks int

Line 36: pay_payroll_actions ppa1,

32: 'PAYROLL_ACTION_ID=C',
33: ppa1.payroll_action_id
34: from
35: pay_payroll_actions ppa,
36: pay_payroll_actions ppa1,
37: pay_assignment_actions paa,
38: pay_assignment_actions paa1,
39: pay_action_interlocks int
40: where

Line 64: pay_payroll_actions ppa,

60: per_all_people_f ppf,
61: per_all_assignments_f paf,
62: pay_action_interlocks pai,
63: pay_assignment_actions paa,
64: pay_payroll_actions ppa,
65: pay_assignment_actions paa_mag
66: WHERE
67: ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
68: AND paa.payroll_action_id = ppa.payroll_action_id