APPS.HXT_TIME_DETAIL dependencies on HXT_EARN_GROUP_TYPES

Line 86: FROM hxt_earn_group_types egt

82:
83: CURSOR check_spc_dy_eg
84: IS
85: SELECT 'x'
86: FROM hxt_earn_group_types egt
87: WHERE egt.NAME = 'OTLR 7th Day Hours';
88:
89: g_spc_dy_eg VARCHAR2 (1) := NULL;
90:

Line 3314: FROM hxt_earn_groups eg, hxt_earn_group_types egt

3310:
3311: CURSOR worked_elements_cur
3312: IS
3313: SELECT element_type_id
3314: FROM hxt_earn_groups eg, hxt_earn_group_types egt
3315: WHERE eg.egt_id = egt.ID AND egt.NAME = 'OTLR 7th Day Hours';
3316:
3317: l_wrkd_elements_cur worked_elements_cur%ROWTYPE;
3318:

Line 5060: hxt_earn_group_types egt,

5056: SELECT NVL (SUM (hrw.hours), 0)
5057: FROM hxt_det_hours_worked hrw,
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

Line 5100: hxt_earn_group_types egt,

5096: SELECT NVL (SUM (hrw.hours), 0)
5097: FROM hxt_det_hours_worked hrw,
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

Line 6450: hxt_earn_group_types egt,

6446: pay_element_types_f elt2,
6447: hxt_det_hours_worked hrw,
6448: hxt_timecards tim,
6449: hxt_earn_groups erg,
6450: hxt_earn_group_types egt,
6451: hxt_earning_policies erp
6452: WHERE tim.for_person_id = g_person_id
6453: AND hrw.tim_id = tim.ID
6454: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 13181: FROM hxt_earn_group_types hegt, hxt_earn_groups heg

13177: p_egt_id hxt_earn_groups.egt_id%TYPE
13178: )
13179: IS
13180: SELECT 1
13181: FROM hxt_earn_group_types hegt, hxt_earn_groups heg
13182: WHERE hegt.ID = p_egt_id
13183: AND heg.egt_id = p_egt_id
13184: AND heg.element_type_id = p_element_type_id;
13185: