APPS.HXT_TIME_DETAIL dependencies on HXT_ADD_ELEM_INFO_F

Line 2086: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw

2082: COUNT(*) sum_count /*** 4969936 ***/
2083: FROM hxt_sum_hours_worked shw
2084: WHERE tim_id = g_tim_id AND shw.date_worked = g_date_worked
2085: AND not exists ( SELECT 'X' /* Bug: 4489952 */
2086: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2087: WHERE hei.element_type_id = dhw.element_type_id
2088: AND nvl(hei.exclude_from_explosion, 'N') = 'Y'
2089: AND dhw.parent_id = shw.id
2090: AND g_date_worked BETWEEN hei.effective_start_date

Line 2099: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw

2095: SELECT hours, time_in, time_out
2096: FROM hxt_sum_hours_worked shw
2097: WHERE ID = g_id
2098: AND not exists ( SELECT 'X' /* Bug: 4489952 */
2099: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2100: WHERE hei.element_type_id = dhw.element_type_id
2101: AND nvl(hei.exclude_from_explosion, 'N') = 'Y'
2102: AND dhw.parent_id = shw.id
2103: AND g_date_worked BETWEEN hei.effective_start_date

Line 2121: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw

2117: AND shw.time_in <> shw.time_out
2118: )
2119: )
2120: AND not exists ( SELECT 'X' /* Bug: 4489952 */
2121: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2122: WHERE hei.element_type_id = dhw.element_type_id
2123: AND nvl(hei.exclude_from_explosion, 'N') = 'Y'
2124: AND dhw.parent_id = shw.id
2125: AND g_date_worked BETWEEN hei.effective_start_date

Line 5062: hxt_add_elem_info_f aei

5058: hxt_timecards tim,
5059: hxt_earn_groups erg,
5060: hxt_earn_group_types egt,
5061: hxt_earning_policies erp,
5062: hxt_add_elem_info_f aei
5063: WHERE tim.for_person_id = g_person_id
5064: AND hrw.tim_id = tim.ID
5065: AND erp.ID = g_ep_id
5066: AND egt.ID = erp.egt_id

Line 5102: hxt_add_elem_info_f aei

5098: hxt_timecards tim,
5099: hxt_earn_groups erg,
5100: hxt_earn_group_types egt,
5101: hxt_earning_policies erp,
5102: hxt_add_elem_info_f aei
5103: WHERE tim.for_person_id = g_person_id
5104: AND hrw.tim_id = tim.ID
5105: AND erp.ID = g_ep_id
5106: AND egt.ID = erp.egt_id

Line 7833: FROM hxt_add_elem_info_f aei

7829: END IF;
7830:
7831: SELECT NVL (points_assigned, 0)
7832: INTO l_points_assigned
7833: FROM hxt_add_elem_info_f aei
7834: WHERE aei.element_type_id = daily_element_type_id
7835: AND g_date_worked BETWEEN aei.effective_start_date
7836: AND aei.effective_end_date;
7837:

Line 8452: FROM hxt_add_elem_info_f aei

8448: END IF;
8449:
8450: SELECT NVL (points_assigned, 0)
8451: INTO l_points_assigned
8452: FROM hxt_add_elem_info_f aei
8453: WHERE aei.element_type_id = weekly_element_type_id
8454: AND g_date_worked BETWEEN aei.effective_start_date
8455: AND aei.effective_end_date;
8456:

Line 9293: FROM hxt_add_elem_info_f aei

9289: END IF;
9290:
9291: SELECT NVL (points_assigned, 0)
9292: INTO l_points_assigned
9293: FROM hxt_add_elem_info_f aei
9294: WHERE aei.element_type_id = weekly_element_type_id
9295: AND g_date_worked BETWEEN aei.effective_start_date
9296: AND aei.effective_end_date;
9297:

Line 9584: FROM hxt_add_elem_info_f aei

9580: END IF;
9581:
9582: SELECT NVL (points_assigned, 0)
9583: INTO l_points_assigned
9584: FROM hxt_add_elem_info_f aei
9585: WHERE aei.element_type_id = l_combo_elem_id
9586: AND g_date_worked BETWEEN aei.effective_start_date
9587: AND aei.effective_end_date;
9588: