APPS.HXT_TIME_DETAIL dependencies on HXT_DET_HOURS_WORKED_F

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 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 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 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;