APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_MSITES_B

Line 1037: SELECT msite_id FROM JTF_MSITES_B where msite_id = p_msite_id);

1033: l_exists NUMBER;
1034:
1035: CURSOR msite_cur( p_msite_id IN NUMBER ) IS
1036: SELECT 1 from dual where exists (
1037: SELECT msite_id FROM JTF_MSITES_B where msite_id = p_msite_id);
1038: -- and
1039: -- end_date_active is null);
1040: --- sysdate between start_date_active and nvl(end_date_active,sysdate));
1041:

Line 1045: SELECT msite_id FROM JTF_MSITES_B

1041:
1042: CURSOR msite_version_cur( p_msite_id IN NUMBER,
1043: p_object_version_number IN NUMBER ) IS
1044: select 1 from dual where exists (
1045: SELECT msite_id FROM JTF_MSITES_B
1046: WHERE msite_id = p_msite_id
1047: and object_version_number = p_object_version_number);
1048: -- AND
1049: -- end_date_active is null);

Line 1265: JTF_MSITES_B A, JTF_MSITE_LANGUAGES B where

1261:
1262: CURSOR msite_lang_cur( p_msite_id IN NUMBER, p_language_code IN VARCHAR2 ) IS
1263: SELECT 1 from dual where exists (
1264: SELECT b.language_code FROM
1265: JTF_MSITES_B A, JTF_MSITE_LANGUAGES B where
1266: A.msite_id = p_msite_id and
1267: B.msite_id = A.msite_id and
1268: -- A.end_date_active is null AND
1269: B.language_code = p_language_code );

Line 1430: SELECT msite_id FROM JTF_MSITES_B where master_msite_flag='Y';

1426: l_api_name CONSTANT VARCHAR2(40) := 'check_master_msite_exists';
1427: l_msite_id NUMBER := null;
1428:
1429: CURSOR msite_cur IS
1430: SELECT msite_id FROM JTF_MSITES_B where master_msite_flag='Y';
1431:
1432: BEGIN
1433:
1434: OPEN msite_cur;

Line 1638: From jtf_msites_b

1634: RETURN BOOLEAN
1635: AS
1636: Cursor C_Exists(p_access_name Varchar2) Is
1637: Select 'x'
1638: From jtf_msites_b
1639: Where access_name = p_access_name ;
1640: l_exists Varchar2(1);
1641: l_status Boolean := TRUE;
1642: Begin