APPS.PY_ZA_TX_UTL_01032000 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 191: p_AsgId pay_assignment_actions.assignment_id%TYPE

187: END GlbVal;
188:
189: FUNCTION RetroInPrd RETURN BOOLEAN AS
190: CURSOR c_RetActs(
191: p_AsgId pay_assignment_actions.assignment_id%TYPE
192: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
193: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
194: )
195: IS

Line 192: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE

188:
189: FUNCTION RetroInPrd RETURN BOOLEAN AS
190: CURSOR c_RetActs(
191: p_AsgId pay_assignment_actions.assignment_id%TYPE
192: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
193: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
194: )
195: IS
196: SELECT 1

Line 198: , pay_assignment_actions paa

194: )
195: IS
196: SELECT 1
197: FROM pay_payroll_actions ppa
198: , pay_assignment_actions paa
199: WHERE paa.assignment_id = p_AsgId
200: AND paa.action_sequence < p_AsgActSeq
201: AND paa.payroll_action_id = ppa.payroll_action_id
202: AND ppa.time_period_id = p_TimPrdId

Line 206: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;

202: AND ppa.time_period_id = p_TimPrdId
203: AND ppa.action_status = 'C'
204: AND ppa.action_type IN ('O','G');
205:
206: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;
207: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;
208: v_RetActs c_RetActs%ROWTYPE;
209: -- l_RetroInPeriod BOOLEAN DEFAULT FALSE;
210:

Line 218: FROM pay_assignment_actions paa

214: SELECT paa.action_sequence
215: , ppa.time_period_id
216: INTO l_AsgActSeq
217: , l_TimPrdId
218: FROM pay_assignment_actions paa
219: , pay_payroll_actions ppa
220: WHERE paa.assignment_action_id = py_za_tx_01032000.con_ASG_ACT_ID
221: AND paa.payroll_action_id = ppa.payroll_action_id;
222: