APPS.HXT_TIME_SUMMARY dependencies on HXT_ADD_ELEM_INFO_F

Line 608: hxt_add_elem_info_f elem

604: det.time_out,
605: det.element_type_id,
606: 0 del_y_n
607: FROM hxt_det_hours_worked det,
608: hxt_add_elem_info_f elem
609: WHERE det.parent_id = p_id
610: AND det.element_type_id = elem.element_type_id
611: AND elem.earning_category = 'SDF'
612: ORDER BY det.element_type_id,

Line 1558: FROM hxt_add_elem_info_f

1554: l_non_explosion_flag VARCHAR2(1);
1555:
1556: CURSOR check_non_explosion_entry IS
1557: SELECT 'Y'
1558: FROM hxt_add_elem_info_f
1559: WHERE element_type_id = p_element_type_id
1560: AND p_date_worked BETWEEN effective_start_date
1561: AND effective_end_date
1562: AND NVL(exclude_from_explosion, 'N') = 'Y';

Line 2224: FROM hxt_add_elem_info_f hei

2220: /* Bug: 4489952 changes starts here */
2221:
2222: SELECT count(1)
2223: INTO l_non_exp_elem_count
2224: FROM hxt_add_elem_info_f hei
2225: WHERE hei.element_type_id = g_element_type_id
2226: AND g_date_worked BETWEEN hei.effective_start_date
2227: AND hei.effective_end_date
2228: AND NVL(hei.exclude_from_explosion, 'N') = 'Y';

Line 2236: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

2232: SELECT '1'
2233: INTO error_code
2234: FROM SYS.DUAL
2235: WHERE EXISTS (SELECT hrw.id
2236: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2237: WHERE hrw.tim_id = g_TIM_ID
2238: AND hrw.date_worked = g_DATE_WORKED
2239: AND hrw.time_in IS NOT NULL
2240: AND hrw.element_type_id = hei.element_type_id

Line 2258: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

2254: SELECT '1'
2255: INTO error_code
2256: FROM SYS.DUAL
2257: WHERE EXISTS (SELECT hrw.id
2258: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
2259: WHERE hrw.tim_id = g_TIM_ID
2260: AND hrw.date_worked = g_DATE_WORKED
2261: AND hrw.time_in IS NULL
2262: AND hrw.hours<>0