eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_BATCH_VAL dependencies on PER_TIME_PERIODS

Line 263: RETURN per_time_periods.end_date%TYPE

259: RETURN l_error_exist;
260: END errors_exist;
261:
262: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
263: RETURN per_time_periods.end_date%TYPE
264: AS
265: l_proc VARCHAR2 (72) ;
266:
267: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)

Line 270: FROM per_time_periods ptp, hxt_timecards_x htx

266:
267: CURSOR csr_timecard_end_date (p_tim_id hxt_timecards_f.id%TYPE)
268: IS
269: SELECT ptp.end_date
270: FROM per_time_periods ptp, hxt_timecards_x htx
271: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
272:
273: l_tc_end_dt per_time_periods.end_date%TYPE;
274: BEGIN

Line 273: l_tc_end_dt per_time_periods.end_date%TYPE;

269: SELECT ptp.end_date
270: FROM per_time_periods ptp, hxt_timecards_x htx
271: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
272:
273: l_tc_end_dt per_time_periods.end_date%TYPE;
274: BEGIN
275: g_debug :=hr_utility.debug_enabled;
276: if g_debug then
277: l_proc := g_package