APPS.GMD_RECIPE_FETCH_PUB dependencies on GMP_PLANT_RSRC_PARAMETERS

Line 1747: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c

1743:
1744: /* Parameters at the plant resource level */
1745: CURSOR Cur_get_plnt_rsrc (V_resources VARCHAR2, V_parameter_id NUMBER) IS
1746: SELECT p.*
1747: FROM gmp_plant_rsrc_parameters p, cr_rsrc_dtl c
1748: WHERE p.resource_id = c.resource_id
1749: AND organization_id = p_organization_id
1750: AND resources = V_resources
1751: AND parameter_id = V_parameter_id;