APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 688: FROM gmd_recipe_validity_rules

684: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_complete';
685: CURSOR cur_validity_rule(v_recipe_validity_rule_id NUMBER)
686: IS
687: SELECT *
688: FROM gmd_recipe_validity_rules
689: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
690:
691: CURSOR cur_validity_status_type(v_validity_rule_status VARCHAR2)
692: IS

Line 697: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;

693: SELECT status_type
694: FROM gmd_status
695: WHERE status_code=v_validity_rule_status;
696:
697: l_validity_rule gmd_recipe_validity_rules%ROWTYPE;
698: l_status_type GMD_STATUS.status_type%TYPE;
699: error_vr_not_found EXCEPTION;
700: error_validity_status EXCEPTION;
701: error_cmplt_date EXCEPTION;