APPS.BIS_PORTLET_PMREGION dependencies on BISBV_BUSINESS_PLANS

Line 2160: FROM BISBV_BUSINESS_PLANS

2156: v_ind_level_id PLS_INTEGER := p_ind_level_id;
2157:
2158: cursor plan_cur is
2159: SELECT plan_id,short_name,name
2160: FROM BISBV_BUSINESS_PLANS
2161: ORDER BY name;
2162:
2163: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2164: -- added short_names and additional levels

Line 4173: FROM BISBV_BUSINESS_PLANS

4169:
4170:
4171: CURSOR plan_cur is
4172: SELECT plan_id,short_name,name
4173: FROM BISBV_BUSINESS_PLANS
4174: ORDER BY name;
4175:
4176: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4177: cursor bisfv_target_levels_cur(p_tarid in pls_integer) is

Line 5868: FROM BISBV_BUSINESS_PLANS

5864: l_plan_id NUMBER := c_NULL;
5865:
5866: CURSOR cPlan is
5867: SELECT plan_id
5868: FROM BISBV_BUSINESS_PLANS
5869: ORDER BY name;
5870:
5871: BEGIN
5872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6206: , BISBV_BUSINESS_PLANS bp

6202: , bu.LABEL
6203: FROM
6204: bis_user_ind_selections bu
6205: , bis_target_levels bt
6206: , BISBV_BUSINESS_PLANS bp
6207: WHERE
6208: bu.IND_SELECTION_ID = p_ind_sel
6209: AND bu.TARGET_LEVEL_ID = bt.TARGET_LEVEL_ID
6210: AND bu.PLAN_ID = bp.PLAN_ID;