[Home] [Help]
117: RETURN NUMBER IS
118:
119: CURSOR row_cur (in_claim_date IN DATE) IS
120: SELECT pur.row_low_range_or_name
121: FROM pay_user_rows_f pur,pay_user_tables put
122: WHERE pur.user_table_id = put.user_table_id
123: AND put.user_table_name = p_table_name
124: AND (put.business_group_id = p_business_group_id
125: OR put.legislation_code IS NOT NULL)
129:
130: CURSOR col_cur (in_claim_date IN DATE)IS
131: SELECT puc.user_column_name
132: FROM pay_user_columns puc
133: ,pay_user_tables put
134: ,pay_user_column_instances_f puci
135: WHERE puc.user_table_id = put.user_table_id
136: AND put.user_table_name = p_table_name
137: AND puc.user_column_id = puci.user_column_id
561:
562: CURSOR c_get_table_name (c_rates_table VARCHAR2)
563: IS
564: SELECT distinct user_table_name
565: FROM pay_user_tables
566: WHERE user_table_id = c_rates_table
567: AND business_group_id=p_business_group_id;
568:
569: CURSOR c_exst
624: l_get_attr_val c_get_attr_val_temp%ROWTYPE;
625: l_vehicle_details_id PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE;
626: l_rates_table_id NUMBER(9);
627: l_exst VARCHAR2(1);
628: l_rates_table_name pay_user_tables.user_table_name%TYPE;
629: l_get_config_rates c_get_config_rt_temp%ROWTYPE;
630: l_str VARCHAR2(2300);
631: l_str_val VARCHAR2(2300);
632: l_str_info VARCHAR2(2300);
1181: -- Change made by vjhanak
1182: --**********************************************************
1183:
1184: l_effective_date DATE;
1185: l_range_or_match PAY_USER_TABLES.range_or_match%TYPE;
1186: l_table_id PAY_USER_TABLES.user_table_id%TYPE;
1187: l_value PAY_USER_COLUMN_INSTANCES_F.value%TYPE;
1188: g_leg_code VARCHAR2(2);
1189: cached BOOLEAN := FALSE;
1182: --**********************************************************
1183:
1184: l_effective_date DATE;
1185: l_range_or_match PAY_USER_TABLES.range_or_match%TYPE;
1186: l_table_id PAY_USER_TABLES.user_table_id%TYPE;
1187: l_value PAY_USER_COLUMN_INSTANCES_F.value%TYPE;
1188: g_leg_code VARCHAR2(2);
1189: cached BOOLEAN := FALSE;
1190: g_effective_date DATE := NULL;
1231: --
1232: hr_utility.set_location ('hruserdt.get_table_value', 3);
1233: SELECT range_or_match, user_table_id
1234: INTO l_range_or_match, l_table_id
1235: FROM pay_user_tables
1236: WHERE upper(user_table_name) = upper(p_table_name)
1237: AND nvl (business_group_id,
1238: p_bus_group_id) = p_bus_group_id
1239: AND nvl(legislation_code, g_leg_code) = g_leg_code;
1245: INTO l_value
1246: FROM pay_user_column_instances_f CINST
1247: , pay_user_columns C
1248: , pay_user_rows_f R
1249: , pay_user_tables TAB
1250: WHERE TAB.user_table_id = l_table_id
1251: AND C.user_table_id = TAB.user_table_id
1252: AND nvl (C.business_group_id,
1253: p_bus_group_id) = p_bus_group_id
1295: INTO l_value
1296: FROM pay_user_column_instances_f CINST
1297: , pay_user_columns C
1298: , pay_user_rows_f R
1299: , pay_user_tables TAB
1300: WHERE TAB.user_table_id = l_table_id
1301: AND C.user_table_id = TAB.user_table_id
1302: AND nvl (C.business_group_id,
1303: p_bus_group_id) = p_bus_group_id
1345: into l_value
1346: from pay_user_column_instances_f CINST
1347: , pay_user_columns C
1348: , pay_user_rows_f R
1349: , pay_user_tables TAB
1350: where TAB.user_table_id = l_table_id
1351: and C.user_table_id = TAB.user_table_id
1352: and nvl (C.business_group_id,
1353: p_bus_group_id) = p_bus_group_id
1408:
1409: BEGIN
1410: SELECT 'x'
1411: INTO l_dummy
1412: FROM pay_user_tables
1413: WHERE user_table_name = p_table_name
1414: AND (business_group_id = p_business_group_id OR legislation_code is NOT NULL)
1415: AND rownum = 1;
1416: