APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 52: pay_action_interlocks int

48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,
52: pay_action_interlocks int
53: where
54: ppa.payroll_action_id = paa.payroll_action_id
55: and paa.assignment_id = paaf.assignment_id
56: and ppa1.payroll_action_id = p_pactid

Line 69: from pay_action_interlocks pai, pay_assignment_actions paa2

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

Line 94: pay_action_interlocks int

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

Line 118: from pay_action_interlocks pai,

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

Line 695: pay_action_interlocks int

691: select max(paa1.payroll_action_id)
692: into l_context1
693: from pay_assignment_actions paa,
694: pay_assignment_actions paa1,
695: pay_action_interlocks int
696: where int.locking_action_id = paa.assignment_action_id
697: and paa1.assignment_action_id = int.locked_action_id
698: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
699: exception

Line 1222: pay_action_interlocks pai,

1218: paa.assignment_action_id,
1219: paa.payroll_action_id
1220: FROM pay_assignment_actions paa,
1221: pay_payroll_actions ppa,
1222: pay_action_interlocks pai,
1223: pay_action_interlocks pai2
1224: WHERE pai.locking_action_id = p_assg_actid
1225: AND pai.locked_action_id = pai2.locking_action_id
1226: AND pai2.locked_action_id = paa.assignment_action_id

Line 1223: pay_action_interlocks pai2

1219: paa.payroll_action_id
1220: FROM pay_assignment_actions paa,
1221: pay_payroll_actions ppa,
1222: pay_action_interlocks pai,
1223: pay_action_interlocks pai2
1224: WHERE pai.locking_action_id = p_assg_actid
1225: AND pai.locked_action_id = pai2.locking_action_id
1226: AND pai2.locked_action_id = paa.assignment_action_id
1227: AND ppa.payroll_action_id = paa.payroll_action_id