APPS.HXT_BATCH_VAL dependencies on HXT_HOLIDAY_DAYS

Line 673: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd

669: p_day DATE
670: )
671: IS
672: SELECT 1
673: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd
674: WHERE hhc.id = p_hol_cal_id
675: AND hhc.id = hhd.hcl_id
676: AND hhd.holiday_date = p_day
677: AND hhd.hours >= 0;

Line 989: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,

985:
986: PROCEDURE get_holiday_info (
987: p_day IN DATE,
988: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
989: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
990: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
991: )
992: IS
993: l_proc VARCHAR2 (72) := g_package

Line 1002: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc

998: p_day DATE
999: )
1000: IS
1001: SELECT hhd.hours, hhc.element_type_id
1002: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc
1003: WHERE hhd.holiday_date = p_day
1004: AND hhc.id = p_hol_cal_id
1005: AND hhd.hcl_id = hhc.id;
1006: BEGIN

Line 1039: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,

1035: PROCEDURE get_holiday_info (
1036: p_person_id IN per_people_f.person_id%TYPE,
1037: p_day IN DATE,
1038: p_effective_date IN DATE,
1039: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1040: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1041: )
1042: IS
1043: l_proc VARCHAR2 (72) ;

Line 1128: l_hol_hours hxt_holiday_days.hours%TYPE;

1124: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1125: )
1126: IS
1127: l_proc VARCHAR2 (72) ;
1128: l_hol_hours hxt_holiday_days.hours%TYPE;
1129: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1130: BEGIN
1131: g_debug :=hr_utility.debug_enabled;
1132: if g_debug then

Line 1505: l_hol_hours hxt_holiday_days.hours%TYPE;

1501: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1502: )
1503: IS
1504: l_proc VARCHAR2 (72) ;
1505: l_hol_hours hxt_holiday_days.hours%TYPE;
1506: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1507: BEGIN
1508: g_debug :=hr_utility.debug_enabled;
1509: if g_debug then