APPS.PAY_CA_T4_CANCEL_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 56: pay_action_interlocks int

52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,
55: pay_assignment_actions paa1,
56: pay_action_interlocks int
57: where ppa.payroll_action_id = paa.payroll_action_id
58: and paa.assignment_id = paaf.assignment_id
59: and ppa1.payroll_action_id = p_pactid
60: and paaf.person_id between p_stperson and p_endperson

Line 72: from pay_action_interlocks pai, pay_assignment_actions paa2

68: and paa.action_status = 'C'
69: and paa1.action_status = 'C'
70: and paa.assignment_action_id
71: not in (select paa2.assignment_action_id
72: from pay_action_interlocks pai, pay_assignment_actions paa2
73: where paa2.assignment_action_id = pai.locked_action_id
74: and paa2.payroll_action_id =
75: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
76: )

Line 97: pay_action_interlocks int

93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,
96: pay_assignment_actions paa1,
97: pay_action_interlocks int
98: where
99: ppa.payroll_action_id = paa.payroll_action_id
100: and paa.assignment_id = paaf.assignment_id
101: and ppa1.payroll_action_id = p_pactid

Line 121: from pay_action_interlocks pai,

117: and hasa.assignment_id = paf.assignment_id
118: and paf.person_id = paaf.person_id)
119: and paa.assignment_action_id
120: not in (select paa2.assignment_action_id
121: from pay_action_interlocks pai,
122: pay_assignment_actions paa2
123: where paa2.assignment_action_id = pai.locked_action_id
124: and paa2.payroll_action_id =
125: to_number(pay_ca_t4_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))

Line 699: pay_action_interlocks int,

695: select max(paa1.payroll_action_id)
696: into l_context1
697: from pay_assignment_actions paa,
698: pay_assignment_actions paa1,
699: pay_action_interlocks int,
700: pay_payroll_actions ppa
701: where int.locking_action_id = paa.assignment_action_id
702: and paa1.assignment_action_id = int.locked_action_id
703: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 1236: pay_action_interlocks pai,

1232: paa.assignment_action_id,
1233: paa.payroll_action_id
1234: FROM pay_assignment_actions paa,
1235: pay_payroll_actions ppa,
1236: pay_action_interlocks pai,
1237: pay_action_interlocks pai2
1238: WHERE pai.locking_action_id = p_assg_actid
1239: AND pai.locked_action_id = pai2.locking_action_id
1240: AND pai2.locked_action_id = paa.assignment_action_id

Line 1237: pay_action_interlocks pai2

1233: paa.payroll_action_id
1234: FROM pay_assignment_actions paa,
1235: pay_payroll_actions ppa,
1236: pay_action_interlocks pai,
1237: pay_action_interlocks pai2
1238: WHERE pai.locking_action_id = p_assg_actid
1239: AND pai.locked_action_id = pai2.locking_action_id
1240: AND pai2.locked_action_id = paa.assignment_action_id
1241: AND ppa.payroll_action_id = paa.payroll_action_id