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 35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,

31: hours NUMBER,
32: time_in DATE,
33: time_out DATE,
34: element_type_id NUMBER,
35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,

Line 36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,

32: time_in DATE,
33: time_out DATE,
34: element_type_id NUMBER,
35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,

Line 37: tas_id hxt_det_hours_worked.tas_id%TYPE,

33: time_out DATE,
34: element_type_id NUMBER,
35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,

Line 38: location_id hxt_det_hours_worked.location_id%TYPE,

34: element_type_id NUMBER,
35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,

Line 39: sht_id hxt_det_hours_worked.sht_id%TYPE,

35: fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE,
36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,

Line 40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,

36: ffv_cost_center_id hxt_det_hours_worked.ffv_cost_center_id%TYPE,
37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,

Line 41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,

37: tas_id hxt_det_hours_worked.tas_id%TYPE,
38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,

Line 42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,

38: location_id hxt_det_hours_worked.location_id%TYPE,
39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,

Line 43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,

39: sht_id hxt_det_hours_worked.sht_id%TYPE,
40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,

Line 44: amount hxt_det_hours_worked.amount%TYPE,

40: hrw_comment hxt_det_hours_worked.hrw_comment%TYPE,
41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,

Line 45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,

41: ffv_rate_code_id hxt_det_hours_worked.ffv_rate_code_id%TYPE,
42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,

Line 46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,

42: rate_multiple hxt_det_hours_worked.rate_multiple%TYPE,
43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,

Line 47: seqno hxt_det_hours_worked.seqno%TYPE,

43: hourly_rate hxt_det_hours_worked.hourly_rate%TYPE,
44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,

Line 48: created_by hxt_det_hours_worked.created_by%TYPE,

44: amount hxt_det_hours_worked.amount%TYPE,
45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,

Line 49: creation_date hxt_det_hours_worked.creation_date%TYPE,

45: fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE,
46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,

Line 50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,

46: separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE,
47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,

Line 51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,

47: seqno hxt_det_hours_worked.seqno%TYPE,
48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,

Line 52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,

48: created_by hxt_det_hours_worked.created_by%TYPE,
49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,

Line 53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,

49: creation_date hxt_det_hours_worked.creation_date%TYPE,
50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,

Line 54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,

50: last_updated_by hxt_det_hours_worked.last_updated_by%TYPE,
51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,

Line 55: project_id hxt_det_hours_worked.project_id%TYPE,

51: last_update_date hxt_det_hours_worked.last_update_date%TYPE,
52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,

Line 56: job_id hxt_det_hours_worked.job_id%TYPE,

52: last_update_login hxt_det_hours_worked.last_update_login%TYPE,
53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE

Line 57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,

53: effective_start_date hxt_det_hours_worked.effective_start_date%TYPE,
54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
61: );

Line 58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,

54: effective_end_date hxt_det_hours_worked.effective_end_date%TYPE,
55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
61: );
62:

Line 59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,

55: project_id hxt_det_hours_worked.project_id%TYPE,
56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
61: );
62:
63: TYPE re_explode_det_table IS TABLE OF re_explode_det_info

Line 60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE

56: job_id hxt_det_hours_worked.job_id%TYPE,
57: STATE_NAME hxt_det_hours_worked_f.STATE_NAME%TYPE,
58: COUNTY_NAME hxt_det_hours_worked_f.COUNTY_NAME%TYPE,
59: CITY_NAME hxt_det_hours_worked_f.CITY_NAME%TYPE,
60: ZIP_CODE hxt_det_hours_worked_f.ZIP_CODE%TYPE
61: );
62:
63: TYPE re_explode_det_table IS TABLE OF re_explode_det_info
64: INDEX BY BINARY_INTEGER;

Line 147: hxt_det_hours_worked hrw

143: -- hrw.GROUP_ID,
144: hrw.earn_pol_id
145: FROM hxt_pay_element_types_f_ddf_v eltv,
146: pay_element_types_f elt,
147: hxt_det_hours_worked hrw
148: WHERE hrw.tim_id = p_tim_id
149: AND hrw.date_worked =
150: (SELECT MAX (hrw.date_worked)
151: FROM hxt_pay_element_types_f_ddf_v eltv,

Line 153: hxt_det_hours_worked hrw

149: AND hrw.date_worked =
150: (SELECT MAX (hrw.date_worked)
151: FROM hxt_pay_element_types_f_ddf_v eltv,
152: pay_element_types_f elt,
153: hxt_det_hours_worked hrw
154: WHERE hrw.tim_id = p_tim_id
155: AND NVL (hrw.hours, 0) > 0
156: AND elt.element_type_id = hrw.element_type_id
157: AND eltv.hxt_earning_category = 'REG'