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 296: FROM cst_material_ovhd_rules

292:
293: BEGIN
294: SELECT count(*)
295: INTO l_count
296: FROM cst_material_ovhd_rules
297: WHERE transaction_type = l_txn_type
298: AND organization_id = p_organization_id;
299:
300: IF (l_count > 0 ) THEN

Line 304: FROM cst_material_ovhd_rules

300: IF (l_count > 0 ) THEN
301: BEGIN
302: SELECT earn_moh, rule_id, count(*)
303: INTO p_earn_moh,l_rule_id, l_rule_count
304: FROM cst_material_ovhd_rules
305: WHERE transaction_type = l_txn_type
306: AND organization_id = p_organization_id
307: AND item_type = l_item_type
308: GROUP BY earn_moh, rule_id;

Line 317: FROM cst_material_ovhd_rules

313:
314: IF (l_rule_count = 0) THEN
315: SELECT earn_moh, rule_id,count(*)
316: INTO p_earn_moh,l_rule_id,l_rule_count
317: FROM cst_material_ovhd_rules
318: WHERE transaction_type = l_txn_type
319: AND organization_id = p_organization_id
320: AND item_type = 3
321: GROUP BY earn_moh, rule_id;