APPS.ZPB_DRILL_INFO dependencies on ZPB_ANALYSIS_CYCLES

Line 9: l_bp_id zpb_analysis_cycles.analysis_cycle_id%TYPE;

5: , p_drill_info IN VARCHAR2
6: , x_drill_value OUT NOCOPY VARCHAR2
7: , x_result OUT NOCOPY VARCHAR2
8: , x_msg_out OUT NOCOPY VARCHAR2) AS
9: l_bp_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
10: l_ds_code zpb_cycle_datasets.DATASET_CODE%TYPE;
11: l_ledger_id zpb_busarea_ledgers.ledger_id%TYPE;
12: l_ledger_count NUMBER := 0;
13: l_dataset_count NUMBER := 0;

Line 22: (ANALYSIS_CYCLE_ID = (select max(ANALYSIS_CYCLE_ID) from zpb_analysis_cycles

18:
19: -- get the BP id
20: cursor c_ds_id is select DATASET_CODE from zpb_cycle_datasets
21: where (ANALYSIS_CYCLE_ID = l_bp_id) OR
22: (ANALYSIS_CYCLE_ID = (select max(ANALYSIS_CYCLE_ID) from zpb_analysis_cycles
23: where CURRENT_INSTANCE_ID = l_bp_id and
24: status_code = 'COMPLETE'));
25:
26: -- get the BP id