APPS.CSM_AD_SIMPLE_SRCH_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_SIMPLE_SEARCH_ACC ACC
45: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_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:
51: CURSOR c_update(b_lastrundate DATE) IS

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

62: B.ID
63: FROM CSM_AD_SIMPLE_SEARCH_VIEW B
64: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SIMPLE_SEARCH_ACC ACC
65: WHERE ACC.ID=B.ID
66: OR NOT EXISTS(SELECT 1 FROM CSM_AD_SEARCH_TITLE_VIEW C
67: WHERE C.ID= B.SEARCH_TYPE_ID));
68:
69: CURSOR c_get_access_id IS
70: SELECT CSM_AD_SIMPLE_SEARCH_ACC_S.NEXTVAL