APPS.GME_COMPLETE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1176: FROM gmd_recipe_validity_rules

1172: l_batch_header_rec gme_batch_header%ROWTYPE;
1173: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
1174: IS
1175: SELECT *
1176: FROM gmd_recipe_validity_rules
1177: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
1178:
1179: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
1180: IS

Line 1185: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

1181: SELECT status_type
1182: FROM gmd_status
1183: WHERE status_code=v_validity_rule_status;
1184:
1185: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
1186: l_status_type GMD_STATUS.status_type%TYPE;
1187: error_vr_not_found EXCEPTION;
1188: error_validity_status EXCEPTION;
1189: error_batch_type EXCEPTION;