[Home] [Help]
8: p_Default_factor number,
9: x_org_specific_factor OUT NOCOPY NUMBER) AS
10: CURSOR CUR_GET_ACTIVITY_FACTOR IS
11: SELECT activity_factor
12: FROM gmd_recipe_orgn_activities
13: WHERE RECIPE_ID = P_RECIPE_ID
14: AND ROUTINGSTEP_ID = P_ROUTINGSTEP_ID
15: AND OPRN_LINE_ID = P_OPRN_LINE_ID
16: AND ORGANIZATION_ID = substrb(P_DOCUMENT_ID,instrb(P_DOCUMENT_ID,'-',1,1)+1,