APPS.PQP_VRE_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: FROM per_business_groups_perf pbg

26: --
27: CURSOR csr_sec_grp IS
28: SELECT pbg.security_group_id,
29: pbg.legislation_code
30: FROM per_business_groups_perf pbg
31: , pqp_vehicle_repository_f vre
32: WHERE vre.vehicle_repository_id = p_vehicle_repository_id
33: AND pbg.business_group_id = vre.business_group_id;
34:

Line 101: FROM per_business_groups_perf pbg

97: -- Declare cursor
98: --
99: CURSOR csr_leg_code IS
100: SELECT pbg.legislation_code
101: FROM per_business_groups_perf pbg
102: ,pqp_vehicle_repository_f vre
103: WHERE vre.vehicle_repository_id = p_vehicle_repository_id
104: AND pbg.business_group_id = vre.business_group_id;
105: --

Line 1441: l_legislation_code per_business_groups.legislation_code%TYPE;

1437: FUNCTION get_legislation_code
1438: (p_business_group_id IN NUMBER
1439: ) RETURN VARCHAR2 IS
1440: --declare local variables
1441: l_legislation_code per_business_groups.legislation_code%TYPE;
1442:
1443: CURSOR c_get_leg_code IS
1444: SELECT legislation_code
1445: FROM per_business_groups_perf

Line 1445: FROM per_business_groups_perf

1441: l_legislation_code per_business_groups.legislation_code%TYPE;
1442:
1443: CURSOR c_get_leg_code IS
1444: SELECT legislation_code
1445: FROM per_business_groups_perf
1446: WHERE business_group_id =p_business_group_id;
1447:
1448: BEGIN
1449: OPEN c_get_leg_code;