DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_SUM_HOURS_WORKED_F

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