APPS.CSM_AD_SIMPLE_SRCH_EVENT_PKG dependencies on CSM_AD_SIMPLE_SEARCH_ACC_S

Line 6: g_ad_simple_sch_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC_S';

2: /* $Header: csmeassb.pls 120.5 2008/02/22 08:52:06 trajasek noship $ */
3: /*** Globals ***/
4: g_ad_simple_sch_acc_tab_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC';
5: g_ad_simple_sch_table_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_VIEW';
6: g_ad_simple_sch_seq_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH_ACC_S';
7: g_ad_simple_sch_pubi_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SEARCH';
8:
9: g_ad_simple_sch_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG';
10: g_ad_simple_sch_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';

Line 70: SELECT CSM_AD_SIMPLE_SEARCH_ACC_S.NEXTVAL

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
71: FROM DUAL;
72:
73: CURSOR c_get_user_list IS
74: SELECT AU.USER_ID