APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on CN_REPOSITORIES_ALL

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

102: and (cg.end_date_active IS NULL OR p_start_date <= cg.end_date_active)
103: and (p_end_date IS NULL OR p_end_date >= cg.start_date_active);
104:
105: CURSOR get_orgs IS
106: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
107: BEGIN
108: p_return_code := fnd_api.g_ret_sts_success;
109:
110: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN

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

397: and (cg.end_date_active IS NULL OR p_start_date <= cg.end_date_active)
398: and (p_end_date IS NULL OR p_end_date >= cg.start_date_active);
399:
400: CURSOR get_orgs is
401: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
402: BEGIN
403: p_return_code := fnd_api.g_ret_sts_success;
404:
405: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN

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

621: and (cg.end_date_active IS NULL OR p_start_date <= cg.end_date_active)
622: and (p_end_date IS NULL OR p_end_date >= cg.start_date_active);
623:
624: CURSOR get_orgs is
625: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
626: BEGIN
627: p_return_code := fnd_api.g_ret_sts_success;
628:
629: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN

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

829: and (cg.end_date_active IS NULL OR p_start_date <= cg.end_date_active)
830: and (p_end_date IS NULL OR p_end_date >= cg.start_date_active);
831:
832: CURSOR get_orgs IS
833: SELECT org_id FROM cn_repositories_all WHERE status = 'A';
834: BEGIN
835: p_return_code := fnd_api.g_ret_sts_success;
836:
837: IF fnd_profile.value('CN_MARK_EVENTS') <> 'Y' THEN