APPS.GMD_COMMON_VAL dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 1822: FROM GMD_ITEM_SUBSTITUTION_HDR_B

1818: WHERE oprn_id = voprn_id;
1819:
1820: CURSOR get_substitution_owner_orgn_id(vsub_id NUMBER) IS
1821: SELECT owner_organization_id
1822: FROM GMD_ITEM_SUBSTITUTION_HDR_B
1823: WHERE SUBSTITUTION_ID = vsub_id;
1824: l_orgn_id NUMBER;
1825: l_return_status VARCHAR2(10);
1826: BEGIN

Line 1942: From gmd_item_substitution_hdr_b r, gmd_status s

1938: CLOSE get_substitution_owner_orgn_id;
1939:
1940: OPEN Status_cur FOR
1941: Select r.substitution_status, s.version_enabled
1942: From gmd_item_substitution_hdr_b r, gmd_status s
1943: Where r.substitution_id = Entity_id
1944: And r.substitution_status = s.status_code;
1945: FETCH Status_cur INTO l_status, l_version_enabled;
1946: ClOSE Status_cur;