APPS.OTA_CFS_BUS dependencies on OTA_CONFERENCE_SERVERS_TL

Line 459: OTA_CONFERENCE_SERVERS_TL CFT

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')
463: AND CFS.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID

Line 471: from ota_conference_servers_tl cft where

467: /* for Bug 4570526 */
468: cursor csr_name
469: IS
470: select name
471: from ota_conference_servers_tl cft where
472: cft.conference_server_id = P_CONFERENCE_SERVER_ID
473: and CFT.LANGUAGE= USERENV('LANG');
474:
475: l_num number(10);

Line 476: l_name ota_conference_servers_tl.name%type;

472: cft.conference_server_id = P_CONFERENCE_SERVER_ID
473: and CFT.LANGUAGE= USERENV('LANG');
474:
475: l_num number(10);
476: l_name ota_conference_servers_tl.name%type;
477: --
478: begin
479: --
480: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);