DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on ZPB_CYCLE_DATASETS

Line 3048: from ZPB_ANALYSIS_CYCLES A, ZPB_CYCLE_DATASETS B,

3044: where B.VERSION_ID = p_version_id);
3045:
3046: cursor l_ac_datasets(p_ba NUMBER, p_dataset NUMBER) is
3047: select distinct nvl (C.INSTANCE_DESCRIPTION, A.NAME) NAME
3048: from ZPB_ANALYSIS_CYCLES A, ZPB_CYCLE_DATASETS B,
3049: ZPB_ANALYSIS_CYCLE_INSTANCES C
3050: where A.BUSINESS_AREA_ID = p_ba
3051: and A.STATUS_CODE <> 'MARKED_FOR_DELETION'
3052: and A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID