APPS.PER_UTILITY_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 67: from per_time_periods

63: cursor csr_get_payroll_period is
64: select start_date
65: , end_date
66: , period_num
67: from per_time_periods
68: where payroll_id = P_Payroll_ID
69: and P_Date_In_Period between start_date and end_date;
70: --
71: l_start_date date;

Line 329: -- in a year, these must be calculated based on per_time_periods.

325: l_max_ed_cur_year date; -- bug 4956943
326: --
327: -- Bug 1574928
328: -- As bi-weekly, weekly and lunar months can have a variable number of periods
329: -- in a year, these must be calculated based on per_time_periods.
330: -- They are set to zero and counted later on.
331:
332: cursor c_count_periods is
333: select count(*)

Line 334: from per_time_periods ptp

330: -- They are set to zero and counted later on.
331:
332: cursor c_count_periods is
333: select count(*)
334: from per_time_periods ptp
335: where ptp.payroll_id = P_Payroll_ID
336: and ptp.end_date between
337: to_date('01/01/'||to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY')
338: and to_date('31/12/' || to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY');

Line 342: from per_time_periods

338: and to_date('31/12/' || to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY');
339:
340: cursor c_first_date is
341: select start_date
342: from per_time_periods
343: where payroll_id = p_payroll_id
344: and end_date = (select min(end_date)
345: from per_time_periods
346: where payroll_id = p_payroll_id

Line 345: from per_time_periods

341: select start_date
342: from per_time_periods
343: where payroll_id = p_payroll_id
344: and end_date = (select min(end_date)
345: from per_time_periods
346: where payroll_id = p_payroll_id
347: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY'));
348:
349: begin

Line 364: from per_time_periods

360: hr_utility.set_location(l_proc, 10);
361: -- START bug 4956943
362: select max(end_date)
363: into l_max_ed_cur_year
364: from per_time_periods
365: where payroll_id = p_payroll_id
366: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
367: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
368:

Line 373: from per_time_periods

369: if l_max_ed_cur_year < p_calculation_date then
370: hr_utility.set_location(l_proc, 100);
371: select min(start_date)
372: into l_start_date
373: from per_time_periods
374: where payroll_id = p_payroll_id
375: and end_date >= p_calculation_date;
376: else
377: -- END bug 4956943

Line 657: from per_time_periods ptp,

653: -- end of bug 5645232
654: --
655: cursor c_get_date is
656: select ptp.start_date
657: from per_time_periods ptp,
658: pay_payroll_actions ppa,
659: pay_assignment_actions paa
660: where paa.payroll_action_id = ppa.payroll_action_id
661: and ppa.time_period_id = ptp.time_period_id

Line 939: from per_time_periods

935: cursor csr_get_payroll_period is
936: select start_date
937: , end_date
938: , period_num
939: from per_time_periods
940: where payroll_id = P_Payroll_ID
941: and P_Date_In_Period between start_date and end_date;
942: --
943: l_start_date date;

Line 1311: from per_time_periods

1307: l_proc varchar2(72) := g_package||'get_payroll_dtrange';
1308: --
1309: cursor csr_get_payroll_range is
1310: select min(start_date),max(end_date)
1311: from per_time_periods
1312: where payroll_id = P_Payroll_ID;
1313: --
1314: l_start_date date;
1315: l_end_date date;