APPS.HXT_TIME_SUMMARY dependencies on HXT_ADD_ELEM_INFO_F

Line 389: FROM hxt_add_elem_info_f

385: l_non_explosion_flag VARCHAR2(1);
386:
387: CURSOR check_non_explosion_entry IS
388: SELECT 'Y'
389: FROM hxt_add_elem_info_f
390: WHERE element_type_id = p_element_type_id
391: AND p_date_worked BETWEEN effective_start_date
392: AND effective_end_date
393: AND NVL(exclude_from_explosion, 'N') = 'Y';

Line 948: FROM hxt_add_elem_info_f hei

944: /* Bug: 4489952 changes starts here */
945:
946: SELECT count(1)
947: INTO l_non_exp_elem_count
948: FROM hxt_add_elem_info_f hei
949: WHERE hei.element_type_id = g_element_type_id
950: AND g_date_worked BETWEEN hei.effective_start_date
951: AND hei.effective_end_date
952: AND NVL(hei.exclude_from_explosion, 'N') = 'Y';

Line 960: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

956: SELECT '1'
957: INTO error_code
958: FROM SYS.DUAL
959: WHERE EXISTS (SELECT hrw.id
960: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
961: WHERE hrw.tim_id = g_TIM_ID
962: AND hrw.date_worked = g_DATE_WORKED
963: AND hrw.time_in IS NOT NULL
964: AND hrw.element_type_id = hei.element_type_id

Line 982: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

978: SELECT '1'
979: INTO error_code
980: FROM SYS.DUAL
981: WHERE EXISTS (SELECT hrw.id
982: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
983: WHERE hrw.tim_id = g_TIM_ID
984: AND hrw.date_worked = g_DATE_WORKED
985: AND hrw.time_in IS NULL
986: AND hrw.hours<>0