APPS.PAY_FR_OVERTIME dependencies on PER_TIME_PERIODS

Line 660: from per_time_periods

656: --
657: cursor c_week_start_date(p_payroll_id number
658: ,p_date date) is
659: select max(start_date)
660: from per_time_periods
661: where payroll_id = p_payroll_id
662: and p_date >= start_date;
663: --
664: cursor c_week_end_date(p_payroll_id number

Line 667: from per_time_periods

663: --
664: cursor c_week_end_date(p_payroll_id number
665: ,p_date date) is
666: select max(end_date)
667: from per_time_periods
668: where payroll_id = p_payroll_id
669: and p_date >= end_date;
670: --
671: /* Local function to increment the date either with a full year or

Line 816: from per_time_periods o

812: ,p_week_start_date date
813: ,p_week_end_date date) return number is
814: cursor c_weeks is
815: select 'Y'
816: from per_time_periods o
817: where o.payroll_id = p_overtime_payroll_id
818: and o.start_date = p_week_start_date
819: and o.end_date = p_week_end_date;
820: --

Line 857: from per_time_periods o

853: ,p_week_start_date out nocopy date
854: ,p_week_end_date out nocopy date) return number is
855: cursor c_weeks is
856: select o.start_date,o.end_date
857: from per_time_periods o
858: , per_time_periods p
859: where o.prd_information2 = p.time_period_id
860: and p.start_date = p_payroll_start_date
861: and o.payroll_id = p_overtime_payroll_id

Line 858: , per_time_periods p

854: ,p_week_end_date out nocopy date) return number is
855: cursor c_weeks is
856: select o.start_date,o.end_date
857: from per_time_periods o
858: , per_time_periods p
859: where o.prd_information2 = p.time_period_id
860: and p.start_date = p_payroll_start_date
861: and o.payroll_id = p_overtime_payroll_id
862: order by o.start_date;

Line 904: from per_time_periods o

900: ,p_week_start_date out nocopy date
901: ,p_week_end_date out nocopy date) return number is
902: cursor c_weeks is
903: select o.start_date,o.end_date
904: from per_time_periods o
905: , per_time_periods p
906: where o.prd_information2 = p.time_period_id
907: and p.payroll_id = p_payroll_id
908: and p.start_date = p_payroll_start_date

Line 905: , per_time_periods p

901: ,p_week_end_date out nocopy date) return number is
902: cursor c_weeks is
903: select o.start_date,o.end_date
904: from per_time_periods o
905: , per_time_periods p
906: where o.prd_information2 = p.time_period_id
907: and p.payroll_id = p_payroll_id
908: and p.start_date = p_payroll_start_date
909: and o.payroll_id = p_overtime_payroll_id