APPS.IBY_EXT_BANKACCT_PUB dependencies on HZ_PARTY_SITES

Line 2061: FROM HZ_PARTY_SITES

2057: END;
2058: IF(p_party_site_id IS NOT NULL) THEN
2059: SELECT status
2060: INTO l_party_site_status
2061: FROM HZ_PARTY_SITES
2062: WHERE party_site_id = p_party_site_id;
2063:
2064: IF l_party_site_status = 'I' THEN
2065: RAISE L_INVALID_PARTY_SITE;

Line 2084: FROM HZ_PARTY_SITES

2080: l_rec.Org_Type:=NULL;
2081: BEGIN
2082: SELECT status
2083: INTO l_party_site_status
2084: FROM HZ_PARTY_SITES
2085: WHERE party_site_id = p_party_site_id;
2086: EXCEPTION
2087: WHEN OTHERS THEN
2088: RAISE L_INVALID_PARTY_SITE;