APPS.GMD_OPERATION_RESOURCES_PUB dependencies on CR_RSRC_MST

Line 145: FROM cr_rsrc_mst cr, cm_cmpt_mst cm

141: AND b.oprn_line_id = V_oprn_line_id;
142:
143: CURSOR get_resource_det (V_resources VARCHAR2) IS
144: SELECT cr.cost_cmpntcls_id
145: FROM cr_rsrc_mst cr, cm_cmpt_mst cm
146: WHERE cr.cost_cmpntcls_id = cm.cost_cmpntcls_id
147: AND cr.resources = V_resources
148: AND cr.delete_mark = 0
149: AND cm.delete_mark = 0

Line 161: FROM cr_rsrc_mst

157:
158: --Bug#7118558
159: CURSOR Cur_get_resource_usage_uom(V_resources VARCHAR2) IS
160: SELECT std_usage_uom
161: FROM cr_rsrc_mst
162: WHERE resources = V_resources;
163:
164: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
165: l_oprn_id NUMBER;