APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_PROCESS_LOSS

Line 411: -- local cursor to fetch the process_loss from gmd_recipe_process_loss table

407: x_return_code OUT NOCOPY NUMBER ,
408: x_process_loss OUT NOCOPY NUMBER
409: ) IS
410:
411: -- local cursor to fetch the process_loss from gmd_recipe_process_loss table
412:
413: CURSOR get_proc IS
414: SELECT process_loss
415: FROM gmd_recipe_process_loss

Line 415: FROM gmd_recipe_process_loss

411: -- local cursor to fetch the process_loss from gmd_recipe_process_loss table
412:
413: CURSOR get_proc IS
414: SELECT process_loss
415: FROM gmd_recipe_process_loss
416: WHERE recipe_id = p_recipe_id
417: AND organization_id = p_organization_id ;
418:
419: -- local Variables

Line 1951: FROM gmd_recipe_process_loss

1947:
1948: -- Cursor to fetch contiguous indicator at recp-orgn level
1949: CURSOR get_recp_orgn_cont_ind( l_recp_id NUMBER, l_orgn_id NUMBER) IS
1950: SELECT contiguous_ind
1951: FROM gmd_recipe_process_loss
1952: WHERE recipe_id = l_recp_id
1953: AND organization_id = l_orgn_id;
1954:
1955: -- Cursor to fetch contiguous indicator at recipe level