APPS.HXT_UTIL dependencies on PER_TIME_PERIODS

Line 730: from per_time_periods ptp,

726: FUNCTION get_period_end_date(p_batch_id IN NUMBER) return VARCHAR2 IS
727: --
728: cursor csr_period_end IS
729: select ptp.end_date
730: from per_time_periods ptp,
731: hxt_timecards_f htf
732: where htf.batch_id = p_batch_id
733: and htf.time_period_id = ptp.time_period_id;
734: --

Line 737: from per_time_periods ptp,

733: and htf.time_period_id = ptp.time_period_id;
734: --
735: cursor csr_retro_end IS
736: select ptp.end_date
737: from per_time_periods ptp,
738: hxt_det_hours_worked_f hdh,
739: hxt_timecards_f htf
740: where hdh.retro_batch_id = p_batch_id
741: and hdh.tim_id = htf.id

Line 820: FROM per_time_periods

816: -- Returns the end date of pay period a_period_id
817: returned_date DATE DEFAULT NULL; --SPR C166 BY BC
818: BEGIN
819: SELECT start_date INTO returned_date
820: FROM per_time_periods
821: WHERE TIME_PERIOD_ID = a_period_id;
822: RETURN returned_date;
823: EXCEPTION
824: WHEN OTHERS THEN

Line 834: FROM per_time_periods

830: -- Returns the end date of pay period a_period_id
831: returned_date DATE DEFAULT NULL; --SPR C166 BY BC
832: BEGIN
833: SELECT end_date INTO returned_date
834: FROM per_time_periods
835: WHERE TIME_PERIOD_ID = a_period_id;
836: RETURN returned_date;
837: EXCEPTION
838: WHEN OTHERS THEN

Line 2316: from per_time_periods ptp

2312: FUNCTION GetPayrollID(p_PTP_ID NUMBER) RETURN NUMBER IS
2313:
2314: cursor payroll_cur(c_ptp_id NUMBER) is
2315: select ptp.payroll_id
2316: from per_time_periods ptp
2317: where ptp.time_period_id = c_ptp_id;
2318:
2319: l_payroll_id NUMBER := NULL;
2320: