APPS.HXT_TIM_COL_UTIL dependencies on HR_LOOKUPS

Line 381: FROM hr_lookups fcl

377: -- RETURN 1;
378: -- ELSE
379: SELECT fcl.meaning
380: INTO hold_reason_code
381: FROM hr_lookups fcl
382: WHERE fcl.lookup_code = i_earn_reason_code
383: AND i_date_worked BETWEEN NVL(fcl.start_date_active, i_date_worked)
384: AND NVL(fcl.end_date_active, i_date_worked)
385: AND fcl.application_id = g_orcl_hr_app_id_cons

Line 465: FROM hr_lookups fcl

461: o_timecard_source_code OUT NOCOPY VARCHAR2 )RETURN NUMBER IS
462: BEGIN
463: SELECT fcl.lookup_code
464: INTO o_timecard_source_code
465: FROM hr_lookups fcl
466: /* WHERE fcl.meaning = i_timecard_source bug 2398037 */
467: WHERE fcl.lookup_code = 'S'
468: AND i_date_worked BETWEEN NVL(fcl.start_date_active, i_date_worked)
469: AND NVL(fcl.end_date_active, i_date_worked)