APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PER_TIME_PERIODS

Line 12: from per_time_periods PTP

8: l_py_prd_per_yr number;
9: begin
10: select count(ptp.end_date)
11: into l_py_prd_per_yr
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

Line 15: from per_time_periods tperiod,

11: into l_py_prd_per_yr
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;

Line 34: from per_time_periods ptp

30: l_za_pay_mnth_prd_num number ;
31: begin
32: select count(ptp.end_date)
33: into l_za_pay_mnth_prd_num
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

Line 37: from per_time_periods tperiod,

33: into l_za_pay_mnth_prd_num
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: )

Line 44: from per_time_periods tperiod,

40: and tperiod.time_period_id = paction.time_period_id
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: )

Line 167: per_time_periods ptp

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')
171: and paa.action_status = 'C'

Line 204: per_time_periods ptp

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')
208: and paa.action_status = 'C'

Line 241: per_time_periods ptp

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')
245: and paa.action_status = 'C'

Line 277: per_time_periods ptp

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')
281: and paa.action_status = 'C'

Line 517: from per_time_periods ptp

513: ) is
514:
515: cursor csr_ee_end_date(p_payroll_id number) is
516: select ptp.end_date
517: from per_time_periods ptp
518: where ptp.payroll_id = p_payroll_id
519: and p_reflection_date between start_date and end_date ;
520:
521: cursor csr_ele_link_id (p_ele_type_id number) is

Line 835: from per_time_periods

831: hr_utility.set_location(l_proc_name,40);
832:
833: select start_date,end_date
834: into l_prev_entry_start_date, l_prev_entry_end_date
835: from per_time_periods
836: where time_period_id = p_time_prd_id ;
837:
838: hr_utility.trace('Prev entry Start Date:'||to_char(l_prev_entry_start_date));
839: hr_utility.trace('Prev entry End Date:'||to_char(l_prev_entry_end_date));