DBA Data[Home] [Help]

APPS.CSM_COUNTER_PROPERTY_EVENT_PKG dependencies on CSI_COUNTER_PROPERTIES_B

Line 12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_COUNTER_PROPERTIES_B';

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 :=
16: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');

Line 32: CSI_COUNTER_PROPERTIES_B B,

28: SELECT
29: B.COUNTER_PROPERTY_ID ,
30: B.COUNTER_ID
31: FROM
32: CSI_COUNTER_PROPERTIES_B B,
33: CSM_COUNTERS_ACC CACC
34: WHERE B.COUNTER_ID = CACC.COUNTER_ID
35: AND CACC.USER_ID = c_user_id
36: AND CACC.COUNTER_ID = c_counter_id

Line 93: CSI_COUNTER_PROPERTIES_B B,

89: SELECT
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;

Line 149: CSI_COUNTER_PROPERTIES_B B,

145: SELECT
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;