DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on PER_BUSINESS_GROUPS

Line 1223: FROM per_business_groups PBG

1219: RETURN VARCHAR2
1220: IS
1221: CURSOR csr_get_legislation_code IS
1222: SELECT PBG.legislation_code
1223: FROM per_business_groups PBG
1224: WHERE PBG.business_group_id = ota_general.get_business_group_id;
1225:
1226: l_legislation_code per_business_groups.legislation_code%TYPE;
1227: BEGIN

Line 1226: l_legislation_code per_business_groups.legislation_code%TYPE;

1222: SELECT PBG.legislation_code
1223: FROM per_business_groups PBG
1224: WHERE PBG.business_group_id = ota_general.get_business_group_id;
1225:
1226: l_legislation_code per_business_groups.legislation_code%TYPE;
1227: BEGIN
1228: OPEN csr_get_legislation_code;
1229: FETCH csr_get_legislation_code INTO l_legislation_code;
1230: CLOSE csr_get_legislation_code;