APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PAY_PAYROLL_ACTIONS

Line 16: pay_payroll_actions paction

12: from per_time_periods PTP
13: where ptp.prd_information1 =
14: (select tperiod.prd_information1
15: from per_time_periods tperiod,
16: pay_payroll_actions paction
17: where paction.payroll_action_id = p_payroll_action_id
18: and tperiod.time_period_id = paction.time_period_id)
19: and ptp.payroll_id = p_payroll_id;
20:

Line 38: pay_payroll_actions paction

34: from per_time_periods ptp
35: where ptp.pay_advice_date =
36: (select tperiod.pay_advice_date
37: from per_time_periods tperiod,
38: pay_payroll_actions paction
39: where paction.payroll_action_id = p_payroll_action_id
40: and tperiod.time_period_id = paction.time_period_id
41: )
42: and ptp.end_date <=

Line 45: pay_payroll_actions paction

41: )
42: and ptp.end_date <=
43: (select tperiod.end_date
44: from per_time_periods tperiod,
45: pay_payroll_actions paction
46: where paction.payroll_action_id = p_payroll_action_id
47: and tperiod.time_period_id = paction.time_period_id
48: )
49: and ptp.payroll_id = p_payroll_id;

Line 166: pay_payroll_actions ppa,

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
170: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 203: pay_payroll_actions ppa,

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
207: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 240: pay_payroll_actions ppa,

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
244: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 276: pay_payroll_actions ppa,

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
280: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')

Line 1072: from pay_payroll_actions ppa

1068: ,l_eff_date
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 ;