APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PER_BUSINESS_GROUPS

Line 12: l_legislation_code_l per_business_groups.legislation_code%TYPE;

8: FUNCTION get_legislation_code (p_business_group_id IN NUMBER)
9: RETURN VARCHAR2
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

Line 17: FROM per_business_groups

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;
19:
20: RETURN (l_legislation_code_l);
21: hr_utility.trace('Leaving Legislation code' );

Line 1224: FROM per_business_groups

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
1225: WHERE business_group_id = p_bus_group_id;
1226: cached := TRUE;
1227: END IF;
1228: END;