DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_HOLIDAY_CALENDARS

Line 421: ,hxt_holiday_calendars hcl

417: -- the day before and the day after the date passed
418: CURSOR holiday_cur IS
419: select hdy.id, hdy.hours, hdy.holiday_date
420: from hxt_holiday_days hdy
421: ,hxt_holiday_calendars hcl
422: where hdy.holiday_date between p_date - 1 and p_date + 1
423: and hdy.hcl_id = hcl.id
424: and p_date between hcl.effective_start_date
425: and hcl.effective_end_date

Line 597: , hxt_holiday_calendars hcl

593: , egp.round_up
594: , hcl.element_type_id
595: FROM
596: hxt_earning_policies egp
597: , hxt_holiday_calendars hcl
598: , hxt_per_aei_ddf_v aeiv
599: , per_all_assignments_f asm
600: WHERE asm.assignment_id = p_assignment_id
601: AND asm.assignment_id = aeiv.assignment_id