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 425: -- in a year, these must be calculated based on per_time_periods.

421: l_max_ed_cur_year date; -- bug 4956943
422: --
423: -- Bug 1574928
424: -- As bi-weekly, weekly and lunar months can have a variable number of periods
425: -- in a year, these must be calculated based on per_time_periods.
426: -- They are set to zero and counted later on.
427:
428: cursor c_count_periods is
429: select count(*)

Line 430: from per_time_periods ptp

426: -- They are set to zero and counted later on.
427:
428: cursor c_count_periods is
429: select count(*)
430: from per_time_periods ptp
431: where ptp.payroll_id = P_Payroll_ID
432: and ptp.end_date between
433: to_date('01/01/'||to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY')
434: and to_date('31/12/' || to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY');

Line 438: from per_time_periods

434: and to_date('31/12/' || to_char(P_Calculation_Date, 'YYYY'), 'DD/MM/YYYY');
435:
436: cursor c_first_date is
437: select start_date
438: from per_time_periods
439: where payroll_id = p_payroll_id
440: and end_date = (select min(end_date)
441: from per_time_periods
442: where payroll_id = p_payroll_id

Line 441: from per_time_periods

437: select start_date
438: from per_time_periods
439: where payroll_id = p_payroll_id
440: and end_date = (select min(end_date)
441: from per_time_periods
442: where payroll_id = p_payroll_id
443: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY'));
444:
445: begin

Line 460: from per_time_periods

456: hr_utility.set_location(l_proc, 10);
457: -- START bug 4956943
458: select max(end_date)
459: into l_max_ed_cur_year
460: from per_time_periods
461: where payroll_id = p_payroll_id
462: and to_char(end_date, 'YYYY') = to_char(p_calculation_date, 'YYYY');
463: hr_utility.trace(l_proc || ' ' || l_max_ed_cur_year);
464:

Line 469: from per_time_periods

465: if l_max_ed_cur_year < p_calculation_date then
466: hr_utility.set_location(l_proc, 100);
467: select min(start_date)
468: into l_start_date
469: from per_time_periods
470: where payroll_id = p_payroll_id
471: and end_date >= p_calculation_date;
472: else
473: -- END bug 4956943

Line 753: from per_time_periods ptp,

749: -- end of bug 5645232
750: --
751: cursor c_get_date is
752: select ptp.start_date
753: from per_time_periods ptp,
754: pay_payroll_actions ppa,
755: pay_assignment_actions paa
756: where paa.payroll_action_id = ppa.payroll_action_id
757: and ppa.time_period_id = ptp.time_period_id

Line 1035: from per_time_periods

1031: cursor csr_get_payroll_period is
1032: select start_date
1033: , end_date
1034: , period_num
1035: from per_time_periods
1036: where payroll_id = P_Payroll_ID
1037: and P_Date_In_Period between start_date and end_date;
1038: --
1039: l_start_date date;

Line 1407: from per_time_periods

1403: l_proc varchar2(72) := g_package||'get_payroll_dtrange';
1404: --
1405: cursor csr_get_payroll_range is
1406: select min(start_date),max(end_date)
1407: from per_time_periods
1408: where payroll_id = P_Payroll_ID;
1409: --
1410: l_start_date date;
1411: l_end_date date;