APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 630: FROM gmd_recipe_validity_rules

626: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_complete';
627: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
628: IS
629: SELECT *
630: FROM gmd_recipe_validity_rules
631: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
632:
633: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
634: IS

Line 639: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

635: SELECT status_type
636: FROM gmd_status
637: WHERE status_code=v_validity_rule_status;
638:
639: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
640: l_status_type GMD_STATUS.status_type%TYPE;
641: error_vr_not_found EXCEPTION;
642: error_validity_status EXCEPTION;
643: error_cmplt_date EXCEPTION;