APPS.IBE_DSPMGRVALIDATION_GRP dependencies on IBE_MSITES_B

Line 1066: FROM IBE_MSITES_B where msite_id = p_msite_id and site_type = 'I';

1062:
1063: CURSOR msite_cur( p_msite_id IN NUMBER ) IS
1064: -- SELECT msite_id
1065: SELECT 1
1066: FROM IBE_MSITES_B where msite_id = p_msite_id and site_type = 'I';
1067: -- and
1068: -- end_date_active is null);
1069: --- sysdate between start_date_active and nvl(end_date_active,sysdate));
1070:

Line 1075: FROM IBE_MSITES_B

1071: CURSOR msite_version_cur( p_msite_id IN NUMBER,
1072: p_object_version_number IN NUMBER ) IS
1073: -- SELECT msite_id
1074: SELECT 1
1075: FROM IBE_MSITES_B
1076: WHERE msite_id = p_msite_id
1077: and object_version_number = p_object_version_number and site_type = 'I';
1078: -- AND
1079: -- end_date_active is null);

Line 1298: IBE_MSITES_B A, IBE_MSITE_LANGUAGES B where

1294:
1295: CURSOR msite_lang_cur( p_msite_id IN NUMBER, p_language_code IN VARCHAR2 ) IS
1296: -- SELECT b.language_code
1297: SELECT 1 FROM
1298: IBE_MSITES_B A, IBE_MSITE_LANGUAGES B where
1299: A.msite_id = p_msite_id and
1300: B.msite_id = A.msite_id and
1301: A.site_type = 'I' and
1302: B.language_code = p_language_code ;

Line 1464: SELECT msite_id FROM IBE_MSITES_B where master_msite_flag='Y' and site_type = 'I';

1460: l_api_name CONSTANT VARCHAR2(40) := 'check_master_msite_exists';
1461: l_msite_id NUMBER := null;
1462:
1463: CURSOR msite_cur IS
1464: SELECT msite_id FROM IBE_MSITES_B where master_msite_flag='Y' and site_type = 'I';
1465:
1466: BEGIN
1467:
1468: OPEN msite_cur;

Line 1698: From ibe_msites_b

1694: RETURN BOOLEAN
1695: AS
1696: Cursor C_Exists(p_access_name Varchar2) Is
1697: Select 'x'
1698: From ibe_msites_b
1699: Where access_name = p_access_name and site_type = 'I';
1700: l_exists Varchar2(1);
1701: l_status Boolean := TRUE;
1702: Begin