APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_REPOSITORIES_ALL

Line 98: SELECT org_id FROM cn_repositories_all WHERE status = 'A';

94: or cg.start_date_active between ct.start_date_active and nvl (ct.end_date_active, cg.start_date_active))
95: and nvl(cg.end_date_active, ct.start_date_active) >= ct.start_date_active;
96:
97: CURSOR get_orgs IS
98: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
99:
100: BEGIN
101: x_return_status := fnd_api.g_ret_sts_success;
102:

Line 343: SELECT org_id FROM cn_repositories_all WHERE status = 'A';

339: or cg.start_date_active between ct.start_date_active and nvl (ct.end_date_active, cg.start_date_active))
340: and nvl(cg.end_date_active, ct.start_date_active) >= ct.start_date_active;
341:
342: CURSOR get_orgs IS
343: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
344:
345: BEGIN
346: x_return_status := fnd_api.g_ret_sts_success;
347: