APPS.CST_MOHRULES_PUB dependencies on CST_MATERIAL_OVHD_RULES

Line 46: INSERT INTO cst_material_ovhd_rules

42: err_code :=0;
43:
44: l_stmt_num := 40;
45:
46: INSERT INTO cst_material_ovhd_rules
47: (rule_id,
48: last_update_date,
49: creation_date,
50: last_updated_by,

Line 109: UPDATE cst_material_ovhd_rules

105:
106: BEGIN
107: err_code := 0;
108:
109: UPDATE cst_material_ovhd_rules
110: SET last_update_date = p_last_update_date,
111: last_updated_by = p_last_updated_by,
112: earn_moh = p_earn_moh,
113: selection_criteria = p_selection_criteria,

Line 141: DELETE FROM cst_material_ovhd_rules

137: BEGIN
138:
139: err_code := 0;
140:
141: DELETE FROM cst_material_ovhd_rules
142: WHERE rule_id = p_rule_id;
143:
144:
145: EXCEPTION

Line 301: FROM cst_material_ovhd_rules

297:
298: BEGIN
299: SELECT count(*)
300: INTO l_count
301: FROM cst_material_ovhd_rules
302: WHERE transaction_type = l_txn_type
303: AND organization_id = p_organization_id;
304:
305: IF (l_count > 0 ) THEN

Line 309: FROM cst_material_ovhd_rules

305: IF (l_count > 0 ) THEN
306: BEGIN
307: SELECT earn_moh, rule_id, count(*)
308: INTO p_earn_moh,l_rule_id, l_rule_count
309: FROM cst_material_ovhd_rules
310: WHERE transaction_type = l_txn_type
311: AND organization_id = p_organization_id
312: AND item_type = l_item_type
313: GROUP BY earn_moh, rule_id;

Line 322: FROM cst_material_ovhd_rules

318:
319: IF (l_rule_count = 0) THEN
320: SELECT earn_moh, rule_id,count(*)
321: INTO p_earn_moh,l_rule_id,l_rule_count
322: FROM cst_material_ovhd_rules
323: WHERE transaction_type = l_txn_type
324: AND organization_id = p_organization_id
325: AND item_type = 3
326: GROUP BY earn_moh, rule_id;