DBA Data[Home] [Help]

APPS.GMD_MBR_UTIL_PKG dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 12: FROM gmd_recipe_orgn_activities

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,