APPS.PAY_CA_RL1_CAN_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 32: pay_assignment_actions paa,

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

Line 33: pay_assignment_actions paa1,

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
36: ppa.payroll_action_id = paa.payroll_action_id
37: and ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

Line 84: pay_assignment_actions paa,

80: FROM
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'))

Line 86: pay_assignment_actions paa_mag

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