APPS.GME_COMPLETE_BATCH_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1100: FROM gmd_recipe_validity_rules

1096: l_batch_header_rec gme_batch_header%ROWTYPE;
1097: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
1098: IS
1099: SELECT *
1100: FROM gmd_recipe_validity_rules
1101: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
1102:
1103: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
1104: IS

Line 1109: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

1105: SELECT status_type
1106: FROM gmd_status
1107: WHERE status_code=v_validity_rule_status;
1108:
1109: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
1110: l_status_type GMD_STATUS.status_type%TYPE;
1111: error_vr_not_found EXCEPTION;
1112: error_validity_status EXCEPTION;
1113: error_batch_type EXCEPTION;