APPS.HXT_TIME_SUMMARY dependencies on HXT_SUM_HOURS_WORKED

Line 31: g_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421

27: g_HOURS NUMBER;
28: g_TIME_IN DATE;
29: g_TIME_OUT DATE;
30: g_ELEMENT_TYPE_ID NUMBER;
31: g_FCL_EARN_REASON_CODE HXT_SUM_HOURS_WORKED.FCL_EARN_REASON_CODE%TYPE;--C421
32: g_FFV_COST_CENTER_ID NUMBER;
33: g_FFV_LABOR_ACCOUNT_ID NUMBER;
34: g_TAS_ID NUMBER;
35: g_LOCATION_ID NUMBER;

Line 37: g_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421

33: g_FFV_LABOR_ACCOUNT_ID NUMBER;
34: g_TAS_ID NUMBER;
35: g_LOCATION_ID NUMBER;
36: g_SHT_ID NUMBER;
37: g_HRW_COMMENT HXT_SUM_HOURS_WORKED.HRW_COMMENT%TYPE;--C421
38: g_FFV_RATE_CODE_ID NUMBER;
39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;

Line 42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421

38: g_FFV_RATE_CODE_ID NUMBER;
39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;
42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
44: g_SEQNO NUMBER;
45: g_CREATED_BY NUMBER;
46: g_CREATION_DATE DATE;

Line 43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421

39: g_RATE_MULTIPLE NUMBER;
40: g_HOURLY_RATE NUMBER;
41: g_AMOUNT NUMBER;
42: g_FCL_TAX_RULE_CODE HXT_SUM_HOURS_WORKED.FCL_TAX_RULE_CODE%TYPE;--C421
43: g_SEPARATE_CHECK_FLAG HXT_SUM_HOURS_WORKED.SEPARATE_CHECK_FLAG%TYPE;--C421
44: g_SEQNO NUMBER;
45: g_CREATED_BY NUMBER;
46: g_CREATION_DATE DATE;
47: g_LAST_UPDATED_BY NUMBER;

Line 55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;

51: g_LATE_STOP NUMBER;
52: g_STANDARD_START NUMBER;
53: g_STANDARD_STOP NUMBER;
54: g_PROJECT_ID NUMBER;
55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
56: g_PAY_STATUS CHAR(1);
57: g_PA_STATUS CHAR(1);
58: g_PERIOD_START_DATE DATE;
59: g_RETRO_BATCH_ID NUMBER;

Line 72: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;

68: --Flags for checking which shift diff premium gets paid for a segment chunk
69: --
70: g_sdf_rule_completed VARCHAR2(1);
71: g_sdf_carryover DATE;
72: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
73: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
74: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
75: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
76:

Line 73: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;

69: --
70: g_sdf_rule_completed VARCHAR2(1);
71: g_sdf_carryover DATE;
72: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
73: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
74: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
75: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
76:
77:

Line 74: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;

70: g_sdf_rule_completed VARCHAR2(1);
71: g_sdf_carryover DATE;
72: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
73: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
74: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
75: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
76:
77:
78: --Function and Procedure declarations

Line 75: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;

71: g_sdf_carryover DATE;
72: g_STATE_NAME hxt_sum_hours_worked_f.state_name%type;
73: g_COUNTY_NAME hxt_sum_hours_worked_f.county_name%type;
74: g_CITY_NAME hxt_sum_hours_worked_f.city_name%type;
75: g_ZIP_CODE hxt_sum_hours_worked_f.zip_code%type;
76:
77:
78: --Function and Procedure declarations
79:

Line 960: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

956: SELECT '1'
957: INTO error_code
958: FROM SYS.DUAL
959: WHERE EXISTS (SELECT hrw.id
960: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
961: WHERE hrw.tim_id = g_TIM_ID
962: AND hrw.date_worked = g_DATE_WORKED
963: AND hrw.time_in IS NOT NULL
964: AND hrw.element_type_id = hei.element_type_id

Line 971: FROM hxt_sum_hours_worked hrw

967: AND hei.effective_end_date
968: AND NVL(hei.exclude_from_explosion, 'N') <> 'Y'
969: UNION
970: SELECT hrw.id
971: FROM hxt_sum_hours_worked hrw
972: WHERE hrw.tim_id = g_TIM_ID
973: AND hrw.date_worked = g_DATE_WORKED
974: AND hrw.time_in IS NOT NULL
975: AND hrw.element_type_id is null

Line 982: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei

978: SELECT '1'
979: INTO error_code
980: FROM SYS.DUAL
981: WHERE EXISTS (SELECT hrw.id
982: FROM hxt_sum_hours_worked hrw, hxt_add_elem_info_f hei
983: WHERE hrw.tim_id = g_TIM_ID
984: AND hrw.date_worked = g_DATE_WORKED
985: AND hrw.time_in IS NULL
986: AND hrw.hours<>0

Line 994: FROM hxt_sum_hours_worked hrw

990: AND hei.effective_end_date
991: AND NVL(hei.exclude_from_explosion, 'N') <> 'Y'
992: UNION
993: SELECT hrw.id
994: FROM hxt_sum_hours_worked hrw
995: WHERE hrw.tim_id = g_TIM_ID
996: AND hrw.date_worked = g_DATE_WORKED
997: AND hrw.time_in IS NULL
998: AND hrw.hours<>0