APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on CSM_AD_SEARCH_TITLE_VIEW

Line 47: AND EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C

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

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

61: B.ID
62: FROM CSM_AD_SEARCH_RESULT_VIEW B
63: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_RESULT_ACC ACC
64: WHERE ACC.ID=B.ID
65: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
66: WHERE C.ID= B.SEARCH_TYPE_ID));
67:
68: CURSOR c_get_access_id IS
69: SELECT CSM_AD_SEARCH_RESULT_ACC_S.NEXTVAL