APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 757: FROM gmd_recipe_validity_rules

753: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_release';
754: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
755: IS
756: SELECT *
757: FROM gmd_recipe_validity_rules
758: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
759:
760: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
761: IS

Line 766: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

762: SELECT status_type
763: FROM gmd_status
764: WHERE status_code=v_validity_rule_status;
765:
766: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
767: l_status_type GMD_STATUS.status_type%TYPE;
768: error_vr_not_found EXCEPTION;
769: error_validity_status EXCEPTION;
770: error_future_date EXCEPTION;