APPS.OTA_CFS_BUS dependencies on OTA_CONFERENCE_SERVERS_B

Line 31: , ota_conference_servers_b cfs

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_conference_servers_b cfs
32: where cfs.conference_server_id = p_conference_server_id
33: and pbg.business_group_id = cfs.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_conference_servers_b cfs

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_conference_servers_b cfs
102: where cfs.conference_server_id = p_conference_server_id
103: and pbg.business_group_id = cfs.business_group_id;
104: --
105: -- Declare local variables

Line 423: p_associated_column1 => 'OTA_CONFERENCE_SERVERS_B.BUSINESS_GROUP_ID',

419: Exception
420: WHEN app_exception.application_exception THEN
421:
422: IF hr_multi_message.exception_add(
423: p_associated_column1 => 'OTA_CONFERENCE_SERVERS_B.BUSINESS_GROUP_ID',
424: p_associated_column2 => 'OTA_CONFERENCE_SERVERS_B.CONFERENCE_SERVER_ID')
425: THEN
426:
427: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 424: p_associated_column2 => 'OTA_CONFERENCE_SERVERS_B.CONFERENCE_SERVER_ID')

420: WHEN app_exception.application_exception THEN
421:
422: IF hr_multi_message.exception_add(
423: p_associated_column1 => 'OTA_CONFERENCE_SERVERS_B.BUSINESS_GROUP_ID',
424: p_associated_column2 => 'OTA_CONFERENCE_SERVERS_B.CONFERENCE_SERVER_ID')
425: THEN
426:
427: --hr_utility.set_location(' Leaving:'||v_proc, 22);
428: RAISE;

Line 458: FROM OTA_CONFERENCE_SERVERS_B CFS,

454: v_name_is_unique boolean;
455: --
456: cursor C1 is
457: SELECT 1
458: FROM OTA_CONFERENCE_SERVERS_B CFS,
459: OTA_CONFERENCE_SERVERS_TL CFT
460: WHERE CFT.NAME = P_NAME
461: AND CFS.CONFERENCE_SERVER_ID = CFT.CONFERENCE_SERVER_ID
462: AND CFT.LANGUAGE= USERENV('LANG')