APPS.HXT_TIME_DETAIL dependencies on HXT_DET_HOURS_WORKED_F

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