DBA Data[Home] [Help]

APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on CSM_COUNTER_PROP_VALUES_ACC_S

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

9:
10: /*** Globals ***/
11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_CTR_PROPERTY_READINGS';
13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
14: g_count_prp_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_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_PROP_VALUES');
17:

Line 213: SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,

209: --Cursor Declarations
210: --Insert Cursor
211: CURSOR csr_ctr_prop_reading_ins (c_last_run_date DATE)
212: IS
213: SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,
214: prd.counter_prop_value_id,
215: val_acc.user_id
216: FROM CSI_CTR_PROPERTY_READINGS prd,
217: csm_counter_values_acc val_acc