APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 734: FROM gmd_recipe_validity_rules

730: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_release';
731: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
732: IS
733: SELECT *
734: FROM gmd_recipe_validity_rules
735: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
736:
737: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
738: IS

Line 743: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

739: SELECT status_type
740: FROM gmd_status
741: WHERE status_code=v_validity_rule_status;
742:
743: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
744: l_status_type GMD_STATUS.status_type%TYPE;
745: error_vr_not_found EXCEPTION;
746: error_validity_status EXCEPTION;
747: error_future_date EXCEPTION;