APPS.BIS_PMV_QUERY_PVT dependencies on AK_REGIONS

Line 704: -- report info from ak_regions_vl

700: l_user_session_rec BIS_PMV_SESSION_PVT.SESSION_REC_TYPE;
701: l_parameter_rec BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE;
702: l_parameter_tbl BIS_PMV_PARAMETERS_PVT.PARAMETER_TBL_TYPE;
703:
704: -- report info from ak_regions_vl
705: CURSOR ak_region_cursor (cpRegionCode VARCHAR2) IS
706: SELECT attribute1 disable_viewby,
707: attribute6 user_groupby,
708: attribute7 user_orderby,

Line 714: FROM AK_REGIONS

710: region_object_type report_type,
711: attribute8 plsql_function,
712: attribute10 data_source,
713: attribute11 where_clause
714: FROM AK_REGIONS
715: WHERE region_code = cpRegionCode;
716:
717: l_ak_region_rec BIS_PMV_METADATA_PVT.AK_REGION_REC;
718: l_ak_region_tbl BIS_PMV_METADATA_PVT.AK_REGION_TBL;

Line 878: --get report info from ak_regions_vl

874: l_user_session_rec.user_id := p_user_id;
875: l_user_session_rec.responsibility_id := p_resp_id;
876: l_user_session_rec.schedule_id := p_schedule_id;
877:
878: --get report info from ak_regions_vl
879: if ak_region_cursor%ISOPEN then
880: close ak_region_cursor;
881: end if;
882: open ak_region_cursor(l_user_session_rec.region_code);