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_DET_HOURS_WORKED

Line 23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,

19: hours NUMBER,
20: time_in DATE,
21: time_out DATE,
22: element_type_id NUMBER,
23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,

Line 24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,

20: time_in DATE,
21: time_out DATE,
22: element_type_id NUMBER,
23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,

Line 25: tas_id hxt_det_hours_worked.tas_id%TYPE,

21: time_out DATE,
22: element_type_id NUMBER,
23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,

Line 26: location_id hxt_det_hours_worked.location_id%TYPE,

22: element_type_id NUMBER,
23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,

Line 27: sht_id hxt_det_hours_worked.sht_id%TYPE,

23: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,

Line 28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,

24: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,

Line 29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,

25: tas_id hxt_det_hours_worked.tas_id%TYPE,
26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,

Line 30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,

26: location_id hxt_det_hours_worked.location_id%TYPE,
27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,

Line 31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,

27: sht_id hxt_det_hours_worked.sht_id%TYPE,
28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,

Line 32: amount hxt_det_hours_worked.amount%TYPE,

28: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,

Line 33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,

29: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,

Line 34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,

30: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,

Line 35: seqno hxt_det_hours_worked.seqno%TYPE,

31: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,

Line 36: created_by hxt_det_hours_worked.created_by%TYPE,

32: amount hxt_det_hours_worked.amount%TYPE,
33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,

Line 37: creation_date hxt_det_hours_worked.creation_date%TYPE,

33: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,

Line 38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,

34: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,

Line 39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,

35: seqno hxt_det_hours_worked.seqno%TYPE,
36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,

Line 40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,

36: created_by hxt_det_hours_worked.created_by%TYPE,
37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,

Line 41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,

37: creation_date hxt_det_hours_worked.creation_date%TYPE,
38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,

Line 42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,

38: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,

Line 43: project_id hxt_det_hours_worked.project_id%TYPE,

39: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,

Line 44: job_id hxt_det_hours_worked.job_id%TYPE,

40: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE

Line 45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,

41: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
49: );

Line 46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,

42: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
49: );
50:

Line 47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,

43: project_id hxt_det_hours_worked.project_id%TYPE,
44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
49: );
50:
51: TYPE re_explode_det_table IS TABLE OF re_explode_det_info

Line 48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE

44: job_id hxt_det_hours_worked.job_id%TYPE,
45: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
46: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
47: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
48: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
49: );
50:
51: TYPE re_explode_det_table IS TABLE OF re_explode_det_info
52: INDEX BY BINARY_INTEGER;

Line 135: hxt_det_hours_worked hrw

131: -- hrw.GROUP_ID,
132: hrw.earn_pol_id
133: FROM hxt_pay_element_types_f_ddf_v eltv,
134: pay_element_types_f elt,
135: hxt_det_hours_worked hrw
136: WHERE hrw.tim_id = p_tim_id
137: AND hrw.date_worked =
138: (SELECT MAX (hrw.date_worked)
139: FROM hxt_pay_element_types_f_ddf_v eltv,

Line 141: hxt_det_hours_worked hrw

137: AND hrw.date_worked =
138: (SELECT MAX (hrw.date_worked)
139: FROM hxt_pay_element_types_f_ddf_v eltv,
140: pay_element_types_f elt,
141: hxt_det_hours_worked hrw
142: WHERE hrw.tim_id = p_tim_id
143: AND NVL (hrw.hours, 0) > 0
144: AND elt.element_type_id = hrw.element_type_id
145: AND eltv.hxt_earning_category = 'REG'