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 1890: FROM gmd_recipe_process_loss

1886:
1887: -- Cursor to fetch contiguous indicator at recp-orgn level
1888: CURSOR get_recp_orgn_cont_ind( l_recp_id NUMBER, l_orgn_id NUMBER) IS
1889: SELECT contiguous_ind
1890: FROM gmd_recipe_process_loss
1891: WHERE recipe_id = l_recp_id
1892: AND organization_id = l_orgn_id;
1893:
1894: -- Cursor to fetch contiguous indicator at recipe level