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 86: FROM hxt_earn_groups erg, hxt_earning_policies egp

82: -- SELECT 'exist'
83: -- FROM sys.dual
84: -- WHERE EXISTS (
85: SELECT 'x'
86: FROM hxt_earn_groups erg, hxt_earning_policies egp
87: WHERE egp.ID = g_ep_id
88: AND erg.egt_id = egp.egt_id
89: AND erg.element_type_id = g_element_type_id;
90:

Line 256: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

252:
253: -- Function and Procedure declarations
254: FUNCTION contig_hours_worked (
255: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
256: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
257: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
258: )
259: RETURN hxt_det_hours_worked.hours%TYPE;
260:

Line 267: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

263: -- when there is an SDP.
264:
265: FUNCTION contig_hours_worked2 (
266: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
267: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
268: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
269: )
270: RETURN hxt_det_hours_worked.hours%TYPE;
271:

Line 275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

271:
272:
273: PROCEDURE overtime_hoursoverride (
274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
279: );

Line 893: FROM hxt_earn_groups erg

889:
890: --USEEARNGROUP -- include ANY earnings, not just absences. RTF
891: ( EXISTS (
892: SELECT 1
893: FROM hxt_earn_groups erg
894: WHERE erg.egt_id = egp.egt_id
895: AND erg.element_type_id = elt.element_type_id)
896: AND egp.egt_id IS NOT NULL
897: )

Line 942: FROM hxt_earn_groups erg

938: AND elt.element_type_id = hrw.element_type_id
939: AND (
940: ( EXISTS (
941: SELECT 1
942: FROM hxt_earn_groups erg
943: WHERE erg.egt_id = egp.egt_id
944: AND erg.element_type_id = elt.element_type_id)
945: AND egp.egt_id IS NOT NULL
946: )

Line 995: hxt_earn_groups erg,

991: IS
992: SELECT NVL (SUM (hrw.hours), 0)
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: hxt_earn_groups erg,
996: hxt_earning_policies egp,
997: hxt_per_aei_ddf_v asmv,
998: per_assignments_f asm,
999: hxt_det_hours_worked hrw,

Line 1035: hxt_earn_groups erg,

1031: IS
1032: SELECT NVL (SUM (hrw.hours), 0)
1033: FROM hxt_pay_element_types_f_ddf_v eltv,
1034: pay_element_types_f elt,
1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,
1039: hxt_det_hours_worked_f hrw,

Line 1127: FROM hxt_earn_groups erg

1123: AND ( -- If absence, only include earnings to be counted toward
1124: -- hours to be worked before being eligible for overtime.
1125: ( EXISTS (
1126: SELECT 1
1127: FROM hxt_earn_groups erg
1128: WHERE erg.egt_id = egp.egt_id
1129: AND erg.element_type_id =
1130: elt.element_type_id)
1131: AND eltv.hxt_earning_category = 'ABS'

Line 1181: FROM hxt_earn_groups erg

1177: AND ( -- If absence, only include earnings to be counted toward
1178: -- hours to be worked before being eligible for overtime.
1179: ( EXISTS (
1180: SELECT 1
1181: FROM hxt_earn_groups erg
1182: WHERE erg.egt_id = egp.egt_id
1183: AND erg.element_type_id =
1184: elt.element_type_id)
1185: AND eltv.hxt_earning_category = 'ABS'

Line 1502: FROM hxt_earn_groups erg

1498: -- hours to be worked before being eligible for overtime.
1499: --USEEARNGROUP -- include ANY earnings, not just absences. RTF
1500: ( EXISTS (
1501: SELECT 1
1502: FROM hxt_earn_groups erg
1503: WHERE erg.egt_id = egp.egt_id
1504: AND erg.element_type_id = elt.element_type_id)
1505: AND egp.egt_id IS NOT NULL
1506: )

Line 1549: FROM hxt_earn_groups erg

1545: AND elt.element_type_id = hrw.element_type_id
1546: AND (
1547: ( EXISTS (
1548: SELECT 1
1549: FROM hxt_earn_groups erg
1550: WHERE erg.egt_id = egp.egt_id
1551: AND erg.element_type_id = elt.element_type_id)
1552: AND egp.egt_id IS NOT NULL
1553: )

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

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

Line 6640: hxt_earn_groups erg,

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

Line 6668: hxt_earn_groups erg,

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

Line 8005: FROM hxt_earn_groups eg

8001:
8002: CURSOR elements_in_earn_groups (i_earn_policy NUMBER)
8003: IS
8004: SELECT eg.element_type_id
8005: FROM hxt_earn_groups eg
8006: WHERE eg.egt_id = (SELECT ep.egt_id
8007: FROM hxt_earning_policies ep
8008: WHERE ep.ID = g_ep_id);
8009:

Line 8033: hxt_earn_groups erg,

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

Line 8064: hxt_earn_groups erg,

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

Line 15042: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

15038: --------------------------------------------------------------------------------
15039: --BEGIN HXT11i1
15040: FUNCTION contig_hours_worked (
15041: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15042: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15043: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15044: )
15045: RETURN hxt_det_hours_worked.hours%TYPE
15046: IS

Line 15102: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,

15098: )
15099: AND nvl(eltv.exclude_from_explosion, 'N') <> 'Y'; /* Bug: 4489952 */
15100:
15101: FUNCTION in_earnings_group (
15102: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,
15103: p_egt_id IN hxt_earn_groups.egt_id%TYPE
15104: )
15105: RETURN BOOLEAN
15106: AS

Line 15103: p_egt_id IN hxt_earn_groups.egt_id%TYPE

15099: AND nvl(eltv.exclude_from_explosion, 'N') <> 'Y'; /* Bug: 4489952 */
15100:
15101: FUNCTION in_earnings_group (
15102: p_element_type_id IN hxt_earn_groups.element_type_id%TYPE,
15103: p_egt_id IN hxt_earn_groups.egt_id%TYPE
15104: )
15105: RETURN BOOLEAN
15106: AS
15107: CURSOR csr_in_earnings_group (

Line 15108: p_element_type_id hxt_earn_groups.element_type_id%TYPE,

15104: )
15105: RETURN BOOLEAN
15106: AS
15107: CURSOR csr_in_earnings_group (
15108: p_element_type_id hxt_earn_groups.element_type_id%TYPE,
15109: p_egt_id hxt_earn_groups.egt_id%TYPE
15110: )
15111: IS
15112: SELECT 1

Line 15109: p_egt_id hxt_earn_groups.egt_id%TYPE

15105: RETURN BOOLEAN
15106: AS
15107: CURSOR csr_in_earnings_group (
15108: p_element_type_id hxt_earn_groups.element_type_id%TYPE,
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

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:

Line 15193: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

15189: -- entered by the user.
15190:
15191: FUNCTION contig_hours_worked2 (
15192: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15193: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15194: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15195: )
15196: RETURN hxt_det_hours_worked.hours%TYPE
15197: IS

Line 15232: FROM hxt_earn_groups eg2

15228: -- Added the OR condition to check if the element overridden is
15229: -- part of Earning group.
15230: AND ( sum.element_type_id IS NULL
15231: OR ( EXISTS ( SELECT 1
15232: FROM hxt_earn_groups eg2
15233: WHERE eg2.element_type_id = sum.element_type_id
15234: AND eg2.egt_id = p_egt_id)
15235: )
15236: )

Line 15241: FROM hxt_earn_groups eg

15237: AND hrw.tim_id = p_tim_id
15238: -- Bug 8757974
15239: AND ( hrw.parent_id = g_id
15240: OR ( EXISTS ( SELECT 1
15241: FROM hxt_earn_groups eg
15242: WHERE eg.element_type_id = hrw.element_type_id
15243: AND eg.egt_id = p_egt_id)
15244: )
15245: )

Line 15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,

15272: -------------------------------------------------------------------------------
15273: --
15274: PROCEDURE overtime_hoursoverride (
15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
15280: )