APPS.ZPB_BUSAREA_VAL dependencies on ZPB_BUSINESS_AREAS

Line 2913: l_ba_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;

2909: l_proc_name CONSTANT VARCHAR2(33) := G_PKG_NAME||'.val_against_epb';
2910:
2911: l_refr_vers ZPB_BUSAREA_VERSIONS.VERSION_ID%type;
2912: l_vers_type ZPB_BUSAREA_VERSIONS.VERSION_TYPE%type;
2913: l_ba_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
2914: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
2915: l_name ZPB_ANALYSIS_CYCLES.NAME%type;
2916: l_folder BISM_OBJECTS.FOLDER_ID%type;
2917: l_num NUMBER;

Line 2914: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;

2910:
2911: l_refr_vers ZPB_BUSAREA_VERSIONS.VERSION_ID%type;
2912: l_vers_type ZPB_BUSAREA_VERSIONS.VERSION_TYPE%type;
2913: l_ba_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
2914: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
2915: l_name ZPB_ANALYSIS_CYCLES.NAME%type;
2916: l_folder BISM_OBJECTS.FOLDER_ID%type;
2917: l_num NUMBER;
2918: l_id VARCHAR2(60);

Line 3066: ZPB_BUSINESS_AREAS C

3062: select A.BUSINESS_AREA_ID, A.VERSION_ID, C.DATA_AW, B.VERSION_TYPE
3063: into l_ba_id, l_refr_vers, l_aw, l_vers_type
3064: from ZPB_BUSAREA_VERSIONS A,
3065: ZPB_BUSAREA_VERSIONS B,
3066: ZPB_BUSINESS_AREAS C
3067: where A.BUSINESS_AREA_ID = B.BUSINESS_AREA_ID
3068: and A.VERSION_TYPE = 'R'
3069: and B.VERSION_ID = p_version_id
3070: and C.BUSINESS_AREA_ID = A.BUSINESS_AREA_ID;