DBA Data[Home] [Help]

APPS.OTA_CPR_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 33: from per_business_groups_perf pbg

29: --
30: cursor csr_sec_grp is
31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_course_prerequisites cpr
35: where cpr.activity_version_id = p_activity_version_id
36: and cpr.prerequisite_course_id = p_prerequisite_course_id
37: and pbg.business_group_id = cpr.business_group_id;

Line 112: from per_business_groups_perf pbg

108: -- Declare cursor
109: --
110: cursor csr_leg_code is
111: select pbg.legislation_code
112: from per_business_groups_perf pbg
113: , ota_course_prerequisites cpr
114: where cpr.activity_version_id = p_activity_version_id
115: and cpr.prerequisite_course_id = p_prerequisite_course_id
116: and pbg.business_group_id = cpr.business_group_id;