APPS.PAY_CA_RL1_CAN_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 30: pay_payroll_actions ppa,

26: SELECT distinct
27: 'PAYROLL_ACTION_ID=P',
28: ppa1.payroll_action_id
29: from
30: pay_payroll_actions ppa,
31: pay_payroll_actions ppa1,
32: pay_assignment_actions paa,
33: pay_assignment_actions paa1,
34: pay_action_interlocks int

Line 31: pay_payroll_actions ppa1,

27: 'PAYROLL_ACTION_ID=P',
28: ppa1.payroll_action_id
29: from
30: pay_payroll_actions ppa,
31: pay_payroll_actions ppa1,
32: pay_assignment_actions paa,
33: pay_assignment_actions paa1,
34: pay_action_interlocks int
35: where

Line 49: pay_payroll_actions ppa

45: SELECT distinct
46: 'PAYROLL_ACTION_ID=P',
47: ppa.payroll_action_id
48: from
49: pay_payroll_actions ppa
50: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'));
51:
52: --
53: -- Used by Magnetic RL1 (RL1 format).

Line 85: pay_payroll_actions ppa,

81: per_all_people_f ppf,
82: per_all_assignments_f paf,
83: pay_action_interlocks pai,
84: pay_assignment_actions paa,
85: pay_payroll_actions ppa,
86: pay_assignment_actions paa_mag
87: WHERE
88: ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
89: AND paa.payroll_action_id = ppa.payroll_action_id