APPS.HXT_BATCH_VAL dependencies on PER_TIME_PERIODS

Line 269: RETURN per_time_periods.end_date%TYPE

265: RETURN l_error_exist;
266: END errors_exist;
267:
268: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
269: RETURN per_time_periods.end_date%TYPE
270: AS
271: l_proc VARCHAR2 (72) ;
272:
273: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)

Line 276: FROM per_time_periods ptp, hxt_timecards_x htx

272:
273: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
274: IS
275: SELECT ptp.end_date
276: FROM per_time_periods ptp, hxt_timecards_x htx
277: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
278:
279: l_tc_end_dt per_time_periods.end_date%TYPE;
280: BEGIN

Line 279: l_tc_end_dt per_time_periods.end_date%TYPE;

275: SELECT ptp.end_date
276: FROM per_time_periods ptp, hxt_timecards_x htx
277: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
278:
279: l_tc_end_dt per_time_periods.end_date%TYPE;
280: BEGIN
281: g_debug :=hr_utility.debug_enabled;
282: if g_debug then
283: l_proc := g_package

Line 2265: FROM per_time_periods

2261: RETURN g_period_end_date(p_period_id);
2262: ELSE
2263: SELECT TO_CHAR(end_date,FND_profile.value('ICX_DATE_FORMAT_MASK'))
2264: INTO g_period_end_date(p_period_id)
2265: FROM per_time_periods
2266: WHERE time_period_id = p_period_id;
2267: RETURN g_period_end_date(p_period_id);
2268: END IF;
2269: