APPS.HXT_UTIL dependencies on PER_TIME_PERIODS

Line 726: from per_time_periods ptp,

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

Line 733: from per_time_periods ptp,

729: and htf.time_period_id = ptp.time_period_id;
730: --
731: cursor csr_retro_end IS
732: select ptp.end_date
733: from per_time_periods ptp,
734: hxt_det_hours_worked_f hdh,
735: hxt_timecards_f htf
736: where hdh.retro_batch_id = p_batch_id
737: and hdh.tim_id = htf.id

Line 816: FROM per_time_periods

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

Line 830: FROM per_time_periods

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

Line 2234: from per_time_periods ptp

2230: FUNCTION GetPayrollID(p_PTP_ID NUMBER) RETURN NUMBER IS
2231:
2232: cursor payroll_cur(c_ptp_id NUMBER) is
2233: select ptp.payroll_id
2234: from per_time_periods ptp
2235: where ptp.time_period_id = c_ptp_id;
2236:
2237: l_payroll_id NUMBER := NULL;
2238: