[Home] [Help]
10: IS
11:
12: l_legislation_code_l per_business_groups.legislation_code%TYPE;
13: BEGIN
14: hr_utility.trace('Enter Legislation code');
15: SELECT legislation_code
16: INTO l_legislation_code_l
17: FROM per_business_groups
18: WHERE business_group_id =p_business_group_id;
17: FROM per_business_groups
18: WHERE business_group_id =p_business_group_id;
19:
20: RETURN (l_legislation_code_l);
21: hr_utility.trace('Leaving Legislation code' );
22:
23: EXCEPTION
24: ---------
25: WHEN OTHERS THEN
168: l_effective_date := p_claim_date;
169: END IF;
170:
171: IF p_row_or_column NOT IN ('ROW','COL') THEN
172: --hr_utility.RAISE;
173: return -1;
174: ELSIF p_row_or_column = 'ROW' THEN
175: OPEN row_cur(l_effective_date);
176: LOOP
1216:
1217: -- get the legislation code:
1218: --
1219: BEGIN
1220: hr_utility.set_location (' pqp_get_table_value', 2);
1221: IF cached = FALSE THEN
1222: SELECT legislation_code
1223: INTO g_leg_code
1224: FROM per_business_groups
1228: END;
1229: --
1230: -- get the type of query to be performed, either range or match
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)
1239: AND nvl(legislation_code, g_leg_code) = g_leg_code;
1240: --
1241: IF (l_range_or_match = 'M') THEN -- matched
1242: BEGIN
1243: hr_utility.set_location ('hruserdt.get_table_value', 4);
1244: SELECT CINST.value
1245: INTO l_value
1246: FROM pay_user_column_instances_f CINST
1247: , pay_user_columns C
1339: END;
1340: END;
1341: ELSE -- range
1342: BEGIN
1343: hr_utility.set_location ('hruserdt.get_table_value', 5);
1344: select CINST.value
1345: into l_value
1346: from pay_user_column_instances_f CINST
1347: , pay_user_columns C