APPS.GMD_COMMON_VAL dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 1880: FROM GMD_ITEM_SUBSTITUTION_HDR_B

1876: WHERE oprn_id = voprn_id;
1877:
1878: CURSOR get_substitution_owner_orgn_id(vsub_id NUMBER) IS
1879: SELECT owner_organization_id
1880: FROM GMD_ITEM_SUBSTITUTION_HDR_B
1881: WHERE SUBSTITUTION_ID = vsub_id;
1882: l_orgn_id NUMBER;
1883: l_return_status VARCHAR2(10);
1884: BEGIN

Line 2000: From gmd_item_substitution_hdr_b r, gmd_status s

1996: CLOSE get_substitution_owner_orgn_id;
1997:
1998: OPEN Status_cur FOR
1999: Select r.substitution_status, s.version_enabled
2000: From gmd_item_substitution_hdr_b r, gmd_status s
2001: Where r.substitution_id = Entity_id
2002: And r.substitution_status = s.status_code;
2003: FETCH Status_cur INTO l_status, l_version_enabled;
2004: ClOSE Status_cur;