APPS.ZPB_DRILL_INFO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

  cursor c_bp_id is select instance_id from zpb_measures where type = 'SHARED_VIEW_DATA'
    and name = p_view;

Line: 20

  cursor c_ds_id is select DATASET_CODE from zpb_cycle_datasets
    where (ANALYSIS_CYCLE_ID = l_bp_id) OR
          (ANALYSIS_CYCLE_ID = (select max(ANALYSIS_CYCLE_ID)  from  zpb_analysis_cycles
                                where  CURRENT_INSTANCE_ID = l_bp_id and
                                status_code = 'COMPLETE'));

Line: 28

    select distinct ledger_id from fem_data_locations where dataset_code = cp_ds_id;