APPS.PY_ZA_TX_UTL_01082000 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 224: p_AsgId pay_assignment_actions.assignment_id%TYPE

220: END GlbVal;
221:
222: FUNCTION RetroInPrd RETURN BOOLEAN AS
223: CURSOR c_RetActs(
224: p_AsgId pay_assignment_actions.assignment_id%TYPE
225: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
226: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
227: )
228: IS

Line 225: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE

221:
222: FUNCTION RetroInPrd RETURN BOOLEAN AS
223: CURSOR c_RetActs(
224: p_AsgId pay_assignment_actions.assignment_id%TYPE
225: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
226: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
227: )
228: IS
229: SELECT 1

Line 231: , pay_assignment_actions paa

227: )
228: IS
229: SELECT 1
230: FROM pay_payroll_actions ppa
231: , pay_assignment_actions paa
232: WHERE paa.assignment_id = p_AsgId
233: AND paa.action_sequence < p_AsgActSeq
234: AND paa.payroll_action_id = ppa.payroll_action_id
235: AND ppa.time_period_id = p_TimPrdId

Line 239: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;

235: AND ppa.time_period_id = p_TimPrdId
236: AND ppa.action_status = 'C'
237: AND ppa.action_type IN ('O','G');
238:
239: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;
240: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;
241: v_RetActs c_RetActs%ROWTYPE;
242: -- l_RetroInPeriod BOOLEAN DEFAULT FALSE;
243:

Line 251: FROM pay_assignment_actions paa

247: SELECT paa.action_sequence
248: , ppa.time_period_id
249: INTO l_AsgActSeq
250: , l_TimPrdId
251: FROM pay_assignment_actions paa
252: , pay_payroll_actions ppa
253: WHERE paa.assignment_action_id = py_za_tx_01082000.con_ASG_ACT_ID
254: AND paa.payroll_action_id = ppa.payroll_action_id;
255: