DBA Data[Home] [Help]

APPS.CSM_COUNTER_PROPERTY_EVENT_PKG dependencies on CSM_COUNTER_PROPERTIES_ACC

Line 11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';

7: -- Person Date Comments
8: -----------------------------------------------------------
9:
10: /*** Globals ***/
11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_PROPERTIES_B';
13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
14: g_count_prp_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
15: g_count_prp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';

9:
10: /*** Globals ***/
11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_PROPERTIES_B';
13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
14: g_count_prp_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
15: g_count_prp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
17:

Line 38: FROM CSM_COUNTER_PROPERTIES_ACC PACC

34: WHERE B.COUNTER_ID = CACC.COUNTER_ID
35: AND CACC.USER_ID = c_user_id
36: AND CACC.COUNTER_ID = c_counter_id
37: AND NOT EXISTS( SELECT 1
38: FROM CSM_COUNTER_PROPERTIES_ACC PACC
39: WHERE PACC.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID
40: AND PACC.USER_ID = c_user_id);
41:
42: --variable declarations

Line 94: CSM_COUNTER_PROPERTIES_ACC PACC

90: PACC.ACCESS_ID ,
91: PACC.USER_ID
92: FROM
93: CSI_COUNTER_PROPERTIES_B B,
94: CSM_COUNTER_PROPERTIES_ACC PACC
95: WHERE B.COUNTER_PROPERTY_ID = PACC.COUNTER_PROPERTY_ID
96: AND PACC.USER_ID = c_user_id
97: AND B.COUNTER_ID = c_counter_id;
98:

Line 150: CSM_COUNTER_PROPERTIES_ACC PACC

146: PACC.ACCESS_ID ,
147: B.COUNTER_PROPERTY_ID
148: FROM
149: CSI_COUNTER_PROPERTIES_B B,
150: CSM_COUNTER_PROPERTIES_ACC PACC
151: WHERE B.COUNTER_PROPERTY_ID = PACC.COUNTER_PROPERTY_ID
152: AND PACC.USER_ID = c_user_id
153: AND B.COUNTER_ID = c_counter_id;
154: