508: -- support both analysis cycle ids and current instance ids
509: begin
510: select BUSINESS_AREA_ID
511: into l_business_area_id
512: from ZPB_ANALYSIS_CYCLES
513: where ANALYSIS_CYCLE_ID = p_analysis_cycle_id;
514: exception
515: when no_data_found then
516: -- most likely there will be more than row for the same current instance id
515: when no_data_found then
516: -- most likely there will be more than row for the same current instance id
517: select max(BUSINESS_AREA_ID)
518: into l_business_area_id
519: from ZPB_ANALYSIS_CYCLES
520: where CURRENT_INSTANCE_ID = p_analysis_cycle_id;
521: end;
522:
523: INITIALIZE (p_api_version => p_api_version,