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_PAY dependencies on HXT_DET_HOURS_WORKED_F

Line 49: FROM hxt_det_hours_worked_f

45: AND pay_status = 'R';
46:
47: CURSOR complete_pay_trans IS
48: SELECT 'R'
49: FROM hxt_det_hours_worked_f
50: WHERE tim_id = p_tim_id
51: AND pay_status = 'C';
52:
53: CURSOR retro_pa_trans IS

Line 55: FROM hxt_det_hours_worked_f

51: AND pay_status = 'C';
52:
53: CURSOR retro_pa_trans IS
54: SELECT 'R'
55: FROM hxt_det_hours_worked_f
56: WHERE tim_id = p_tim_id
57: AND pa_status = 'R';
58:
59: CURSOR complete_pa_trans IS

Line 61: FROM hxt_det_hours_worked_f

57: AND pa_status = 'R';
58:
59: CURSOR complete_pa_trans IS
60: SELECT 'R'
61: FROM hxt_det_hours_worked_f
62: WHERE tim_id = p_tim_id
63: AND pa_status = 'C';
64:
65: CURSOR check_for_details IS

Line 73: FROM hxt_det_hours_worked_f det

69: WHERE tim.id = p_tim_id
70: AND tbs.batch_id = tim.batch_id
71: AND tbs.status = 'VT'
72: AND NOT EXISTS (SELECT '1'
73: FROM hxt_det_hours_worked_f det
74: WHERE det.tim_id = tim.id
75: AND NVL(det.hours,0) > 0);
76:
77:

Line 355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

351: -- 1/22/98 SIR092 Hours are not written to premium types of FIXED.
352: --
353: v_amount hxt_det_hours_worked.amount%type := null; --SIR029
354: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
355: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
356:
357: CURSOR next_id_cur IS
358: SELECT hxt_seqno.nextval next_id
359: FROM dual;

Line 392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
391:
392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
393: -- *********************************
394: -- ORACLE END Bugs #465434 & #464850
395: -- *********************************
396:

Line 545: /* INSERT INTO hxt_det_hours_worked_f(id,

541: hr_utility.trace('l_ffv_cost_center_id :'||l_ffv_cost_center_id);
542: end if;
543: END IF;
544:
545: /* INSERT INTO hxt_det_hours_worked_f(id,
546: parent_id,
547: tim_id,
548: date_worked,
549: assignment_id,

Line 617: /* Call dml to insert hours into hxt_det_hours_worked_f */

613: --g_group_id
614: ); */
615:
616:
617: /* Call dml to insert hours into hxt_det_hours_worked_f */
618: if g_debug then
619: hr_utility.set_location('hxt_time_pay.INSERT_HRS',140);
620: end if;
621:

Line 774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

770: -- Premium override multiple
771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error

Line 775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;

771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error
779: l_location VARCHAR2(120); -- Current Path for locating source

Line 776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;

772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;
776: l_time_out hxt_det_hours_worked_f.time_out%TYPE ;
777: l_seqno NUMBER; -- Line seqno
778: l_error_code NUMBER DEFAULT 0; -- Default to no error
779: l_location VARCHAR2(120); -- Current Path for locating source
780: -- of errors

Line 787: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;

783: l_min_detail_seqno NUMBER;
784: l_max_detail_seqno NUMBER;
785:
786: l_costable_type pay_element_links_f.costable_type%TYPE;
787: l_ffv_cost_center_id hxt_det_hours_worked_f.ffv_cost_center_id%TYPE;
788:
789: l_rowid ROWID;
790: l_object_version_number NUMBER DEFAULT NULL;
791: l_id NUMBER;

Line 1449: UPDATE hxt_det_hours_worked_f hrw

1445:
1446: if g_debug then
1447: hr_utility.set_location('hxt_time_pay.Gen_Premiums',340);
1448: end if;
1449: UPDATE hxt_det_hours_worked_f hrw
1450: SET rate_multiple = l_mult
1451: WHERE hrw.rowid = hrw_rowid;
1452: EXCEPTION
1453: WHEN OTHERS THEN

Line 1482: UPDATE hxt_det_hours_worked_f hrw

1478:
1479: if g_debug then
1480: hr_utility.set_location('hxt_time_pay.Gen_Premiums',380);
1481: end if;
1482: UPDATE hxt_det_hours_worked_f hrw
1483: SET hourly_rate = l_rate
1484: WHERE hrw.rowid = hrw_rowid;
1485: EXCEPTION
1486: WHEN OTHERS THEN

Line 1558: /* INSERT into hxt_det_hours_worked_f

1554: hr_utility.set_location('hxt_time_pay.Gen_Premiums',450);
1555: end if;
1556:
1557:
1558: /* INSERT into hxt_det_hours_worked_f
1559: (ID,PARENT_ID,TIM_ID,
1560: DATE_WORKED,ASSIGNMENT_ID,
1561: HOURS,TIME_IN,TIME_OUT,
1562: ELEMENT_TYPE_ID,FCL_EARN_REASON_CODE,