APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on CSM_AD_SEARCH_TITLE_ACC_S

Line 6: g_ad_sch_title_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC_S';

2: /* $Header: csmeastb.pls 120.5 2008/02/22 08:52:31 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_sch_title_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC';
5: g_ad_sch_title_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_VIEW';
6: g_ad_sch_title_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE_ACC_S';
7: g_ad_sch_title_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SEARCH_TITLE';
8:
9: g_ad_sch_title_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_TITLE_EVENT_PKG';
10: g_ad_sch_title_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

Line 65: SELECT CSM_AD_SEARCH_TITLE_ACC_S.NEXTVAL

61: WHERE NOT EXISTS (SELECT 1 FROM CSM_AD_SEARCH_TITLE_ACC ACC
62: WHERE ACC.SEARCH_TYPE=B.SEARCH_TYPE);
63:
64: CURSOR c_get_access_id IS
65: SELECT CSM_AD_SEARCH_TITLE_ACC_S.NEXTVAL
66: FROM DUAL;
67:
68: CURSOR c_get_user_list IS
69: SELECT USER_ID