APPS.HXT_TIME_DETAIL dependencies on HXT_EARN_GROUP_TYPES

Line 96: FROM hxt_earn_group_types egt

92:
93: CURSOR check_spc_dy_eg
94: IS
95: SELECT 'x'
96: FROM hxt_earn_group_types egt
97: WHERE egt.NAME = 'OTLR 7th Day Hours';
98:
99: g_spc_dy_eg VARCHAR2 (1) := NULL;
100:

Line 4548: FROM hxt_earn_groups eg, hxt_earn_group_types egt

4544:
4545: CURSOR worked_elements_cur
4546: IS
4547: SELECT element_type_id
4548: FROM hxt_earn_groups eg, hxt_earn_group_types egt
4549: WHERE eg.egt_id = egt.ID AND egt.NAME = 'OTLR 7th Day Hours';
4550:
4551: l_wrkd_elements_cur worked_elements_cur%ROWTYPE;
4552:

Line 4585: FROM hxt_earn_groups eg, hxt_earn_group_types egt

4581:
4582: CURSOR worked_elements_cur
4583: IS
4584: SELECT element_type_id
4585: FROM hxt_earn_groups eg, hxt_earn_group_types egt
4586: WHERE eg.egt_id = egt.ID AND egt.NAME = 'OTLR 7th Day Hours';
4587:
4588: l_wrkd_elements_cur worked_elements_cur%ROWTYPE;
4589:

Line 6594: hxt_earn_group_types egt,

6590: SELECT NVL (SUM (hrw.hours), 0)
6591: FROM hxt_det_hours_worked hrw,
6592: hxt_timecards tim,
6593: hxt_earn_groups erg,
6594: hxt_earn_group_types egt,
6595: hxt_earning_policies erp,
6596: hxt_add_elem_info_f aei
6597: WHERE tim.for_person_id = g_person_id
6598: AND hrw.tim_id = tim.ID

Line 6641: hxt_earn_group_types egt,

6637: SELECT NVL (SUM (hrw.hours), 0)
6638: FROM hxt_det_hours_worked hrw,
6639: hxt_timecards tim,
6640: hxt_earn_groups erg,
6641: hxt_earn_group_types egt,
6642: hxt_earning_policies erp,
6643: hxt_add_elem_info_f aei
6644: WHERE tim.for_person_id = g_person_id
6645: AND hrw.tim_id = tim.ID

Line 6669: hxt_earn_group_types egt,

6665: SELECT NVL (SUM (hrw.hours), 0)
6666: FROM hxt_det_hours_worked_f hrw,
6667: hxt_timecards_f tim,
6668: hxt_earn_groups erg,
6669: hxt_earn_group_types egt,
6670: hxt_earning_policies erp,
6671: hxt_add_elem_info_f aei
6672: WHERE effective_date BETWEEN hrw.effective_start_date
6673: AND hrw.effective_end_date

Line 8034: hxt_earn_group_types egt,

8030: pay_element_types_f elt2,
8031: hxt_det_hours_worked hrw,
8032: hxt_timecards tim,
8033: hxt_earn_groups erg,
8034: hxt_earn_group_types egt,
8035: hxt_earning_policies erp
8036: WHERE tim.for_person_id = g_person_id
8037: AND hrw.tim_id = tim.ID
8038: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 8065: hxt_earn_group_types egt,

8061: pay_element_types_f elt2,
8062: hxt_det_hours_worked_f hrw,
8063: hxt_timecards_f tim,
8064: hxt_earn_groups erg,
8065: hxt_earn_group_types egt,
8066: hxt_earning_policies erp
8067: WHERE tim.for_person_id = g_person_id
8068: AND hrw.tim_id = tim.ID
8069: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 15113: FROM hxt_earn_group_types hegt, hxt_earn_groups heg

15109: p_egt_id hxt_earn_groups.egt_id%TYPE
15110: )
15111: IS
15112: SELECT 1
15113: FROM hxt_earn_group_types hegt, hxt_earn_groups heg
15114: WHERE hegt.ID = p_egt_id
15115: AND heg.egt_id = p_egt_id
15116: AND heg.element_type_id = p_element_type_id;
15117: