APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 165: from pay_assignment_actions paa,

161: -- Oct 2007
162: begin
163: select max(paa.action_sequence)
164: into l_Oct_act_seq
165: from pay_assignment_actions paa,
166: pay_payroll_actions ppa,
167: per_time_periods ptp
168: where paa.assignment_id = p_assignment_id
169: and paa.payroll_action_id = ppa.payroll_action_id

Line 202: from pay_assignment_actions paa,

198:
199: begin
200: select max(paa.action_sequence)
201: into l_Nov_act_seq
202: from pay_assignment_actions paa,
203: pay_payroll_actions ppa,
204: per_time_periods ptp
205: where paa.assignment_id = p_assignment_id
206: and paa.payroll_action_id = ppa.payroll_action_id

Line 239: from pay_assignment_actions paa,

235:
236: begin
237: select max(paa.action_sequence)
238: into l_Dec_act_seq
239: from pay_assignment_actions paa,
240: pay_payroll_actions ppa,
241: per_time_periods ptp
242: where paa.assignment_id = p_assignment_id
243: and paa.payroll_action_id = ppa.payroll_action_id

Line 275: from pay_assignment_actions paa,

271:
272: begin
273: select max(paa.action_sequence)
274: into l_Jan_act_seq
275: from pay_assignment_actions paa,
276: pay_payroll_actions ppa,
277: per_time_periods ptp
278: where paa.assignment_id = p_assignment_id
279: and paa.payroll_action_id = ppa.payroll_action_id

Line 1073: ,pay_assignment_actions paa

1069: ,l_time_prd_id
1070: ,l_asg_id
1071: ,l_action_type
1072: from pay_payroll_actions ppa
1073: ,pay_assignment_actions paa
1074: where ppa.payroll_action_id = paa.payroll_action_id
1075: and paa.action_sequence = rec_assact(rec_count).action_seq
1076: and paa.assignment_id = rec_assact(rec_count).assignment_id ;
1077: exception