DBA Data[Home] [Help]

APPS.PAY_CA_RL2_CAN_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 37: pay_assignment_actions paa,

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

Line 38: pay_assignment_actions paa1,

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

Line 63: pay_assignment_actions paa,

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

Line 65: pay_assignment_actions paa_mag

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