eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_DETAIL dependencies on HXT_EARN_GROUPS

Line 76: FROM hxt_earn_groups erg, hxt_earning_policies egp

72: -- SELECT 'exist'
73: -- FROM sys.dual
74: -- WHERE EXISTS (
75: SELECT 'x'
76: FROM hxt_earn_groups erg, hxt_earning_policies egp
77: WHERE egp.ID = g_ep_id
78: AND erg.egt_id = egp.egt_id
79: AND erg.element_type_id = g_element_type_id;
80:

Line 170: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

166:
167: -- Function and Procedure declarations
168: FUNCTION contig_hours_worked (
169: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
170: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
171: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
172: )
173: RETURN hxt_det_hours_worked.hours%TYPE;
174:

Line 177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

173: RETURN hxt_det_hours_worked.hours%TYPE;
174:
175: PROCEDURE overtime_hoursoverride (
176: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
177: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
178: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
179: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
180: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
181: );

Line 769: FROM hxt_earn_groups erg

765:
766: --USEEARNGROUP -- include ANY earnings, not just absences. RTF
767: ( EXISTS (
768: SELECT 1
769: FROM hxt_earn_groups erg
770: WHERE erg.egt_id = egp.egt_id
771: AND erg.element_type_id = elt.element_type_id)
772: AND egp.egt_id IS NOT NULL
773: )

Line 808: hxt_earn_groups erg,

804: IS
805: SELECT NVL (SUM (hrw.hours), 0)
806: FROM hxt_pay_element_types_f_ddf_v eltv,
807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,
811: per_assignments_f asm,
812: hxt_det_hours_worked hrw,

Line 882: FROM hxt_earn_groups erg

878: AND ( -- If absence, only include earnings to be counted toward
879: -- hours to be worked before being eligible for overtime.
880: ( EXISTS (
881: SELECT 1
882: FROM hxt_earn_groups erg
883: WHERE erg.egt_id = egp.egt_id
884: AND erg.element_type_id =
885: elt.element_type_id)
886: AND eltv.hxt_earning_category = 'ABS'

Line 1118: FROM hxt_earn_groups erg

1114: -- hours to be worked before being eligible for overtime.
1115: --USEEARNGROUP -- include ANY earnings, not just absences. RTF
1116: ( EXISTS (
1117: SELECT 1
1118: FROM hxt_earn_groups erg
1119: WHERE erg.egt_id = egp.egt_id
1120: AND erg.element_type_id = elt.element_type_id)
1121: AND egp.egt_id IS NOT NULL
1122: )

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 5059: hxt_earn_groups erg,

5055: IS
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

Line 5099: hxt_earn_groups erg,

5095: IS
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

Line 6426: FROM hxt_earn_groups eg

6422:
6423: CURSOR elements_in_earn_groups (i_earn_policy NUMBER)
6424: IS
6425: SELECT eg.element_type_id
6426: FROM hxt_earn_groups eg
6427: WHERE eg.egt_id = (SELECT ep.egt_id
6428: FROM hxt_earning_policies ep
6429: WHERE ep.ID = g_ep_id);
6430:

Line 6449: hxt_earn_groups erg,

6445: FROM hxt_pay_element_types_f_ddf_v eltv,
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

Line 13135: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

13131: --------------------------------------------------------------------------------
13132: --BEGIN HXT11i1
13133: FUNCTION contig_hours_worked (
13134: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13135: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13136: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
13137: )
13138: RETURN hxt_det_hours_worked.hours%TYPE
13139: IS

Line 13170: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,

13166: )
13167: AND nvl(eltv.exclude_from_explosion, 'N') <> 'Y'; /* Bug: 4489952 */
13168:
13169: FUNCTION in_earnings_group (
13170: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,
13171: p_egt_id IN hxt_earn_groups.egt_id%TYPE
13172: )
13173: RETURN BOOLEAN
13174: AS

Line 13171: p_egt_id IN hxt_earn_groups.egt_id%TYPE

13167: AND nvl(eltv.exclude_from_explosion, 'N') <> 'Y'; /* Bug: 4489952 */
13168:
13169: FUNCTION in_earnings_group (
13170: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,
13171: p_egt_id IN hxt_earn_groups.egt_id%TYPE
13172: )
13173: RETURN BOOLEAN
13174: AS
13175: CURSOR csr_in_earnings_group (

Line 13176: p_element_type_id hxt_earn_groups.element_type_id%TYPE,

13172: )
13173: RETURN BOOLEAN
13174: AS
13175: CURSOR csr_in_earnings_group (
13176: p_element_type_id hxt_earn_groups.element_type_id%TYPE,
13177: p_egt_id hxt_earn_groups.egt_id%TYPE
13178: )
13179: IS
13180: SELECT 1

Line 13177: p_egt_id hxt_earn_groups.egt_id%TYPE

13173: RETURN BOOLEAN
13174: AS
13175: CURSOR csr_in_earnings_group (
13176: p_element_type_id hxt_earn_groups.element_type_id%TYPE,
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

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:

Line 13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

13226: -------------------------------------------------------------------------------
13227: --
13228: PROCEDURE overtime_hoursoverride (
13229: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
13230: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
13231: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
13232: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
13233: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
13234: )