APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on CSM_AD_SEARCH_TITLE_VIEW

Line 45: AND EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C

41: ACC.ID
42: FROM CSM_AD_SEARCH_REGION_ACC ACC
43: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_VIEW B
44: WHERE B.ID=ACC.ID
45: AND EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
46: WHERE C.ID= B.SEARCH_TYPE_ID));
47:
48: CURSOR c_update(b_lastrundate DATE) IS
49: SELECT ACC.ACCESS_ID,

Line 63: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C

59: B.ID
60: FROM CSM_AD_SEARCH_REGION_VIEW B
61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_REGION_ACC ACC
62: WHERE ACC.ID=B.ID
63: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
64: WHERE C.ID= B.SEARCH_TYPE_ID));
65:
66: CURSOR c_get_access_id IS
67: SELECT CSM_AD_SEARCH_REGION_ACC_S.NEXTVAL