DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_HOLIDAY_CALENDARS

Line 417: ,hxt_holiday_calendars hcl

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

Line 593: , hxt_holiday_calendars hcl

589: , egp.round_up
590: , hcl.element_type_id
591: FROM
592: hxt_earning_policies egp
593: , hxt_holiday_calendars hcl
594: , hxt_per_aei_ddf_v aeiv
595: , per_all_assignments_f asm
596: WHERE asm.assignment_id = p_assignment_id
597: AND asm.assignment_id = aeiv.assignment_id