APPS.BIS_PMV_PMF_PVT dependencies on BISBV_TARGET_LEVELS

Line 1723: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;

1719:
1720: -- pvt retrieve------------------------------
1721:
1722: l_bisfv_targets_rec bisfv_targets%ROWTYPE;
1723: l_bisbv_target_levels_rec bisbv_target_levels%ROWTYPE;
1724: l_plan_id NUMBER;
1725: l_Business_Plan_Rec BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
1726: l_Business_Plan_Rec_p BIS_BUSINESS_PLAN_PUB.Business_Plan_Rec_Type;
1727: l_org_level_value_id VARCHAR2(250);

Line 1786: INTO l_bisbv_target_levels_rec

1782: = FND_API.G_TRUE
1783: AND l_Target_Rec.Target_Level_ID IS NOT NULL
1784: ) THEN
1785: SELECT *
1786: INTO l_bisbv_target_levels_rec
1787: FROM bisbv_target_levels bisbv_target_levels
1788: WHERE bisbv_target_levels.TARGET_LEVEL_ID
1789: = l_Target_Rec.Target_Level_ID;
1790:

Line 1787: FROM bisbv_target_levels bisbv_target_levels

1783: AND l_Target_Rec.Target_Level_ID IS NOT NULL
1784: ) THEN
1785: SELECT *
1786: INTO l_bisbv_target_levels_rec
1787: FROM bisbv_target_levels bisbv_target_levels
1788: WHERE bisbv_target_levels.TARGET_LEVEL_ID
1789: = l_Target_Rec.Target_Level_ID;
1790:
1791: ---If Plan Id is not given, get Plan Id from Short name

Line 1788: WHERE bisbv_target_levels.TARGET_LEVEL_ID

1784: ) THEN
1785: SELECT *
1786: INTO l_bisbv_target_levels_rec
1787: FROM bisbv_target_levels bisbv_target_levels
1788: WHERE bisbv_target_levels.TARGET_LEVEL_ID
1789: = l_Target_Rec.Target_Level_ID;
1790:
1791: ---If Plan Id is not given, get Plan Id from Short name
1792:

Line 1902: from bisbv_target_levels

1898: Select
1899: COMPUTING_FUNCTION_ID
1900: into
1901: lComputing_Function_Id
1902: from bisbv_target_levels
1903: where target_level_ID =l_bisfv_targets_rec.Target_Level_ID;
1904:
1905: END IF;
1906: