APPS.GMD_OPERATION_RESOURCES_PUB dependencies on CM_CMPT_MST

Line 57: FROM cm_cmpt_mst

53:
54:
55: CURSOR check_cost_cmpntcls_id(v_cost_cmpntcls_id NUMBER) IS
56: SELECT 1
57: FROM cm_cmpt_mst
58: WHERE COST_CMPNTCLS_id = v_cost_cmpntcls_id
59: AND delete_mark = 0;
60:
61: CURSOR check_cost_analysis_code(v_cost_analysis_code VARCHAR2) IS

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 164: l_cost_cmpntcls_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;

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;
166: l_oprn_rsrc_tbl gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;
167: l_rsrc_count NUMBER(5);
168: l_usage_uom VARCHAR2(4);