APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_PARTY_SITE_USES

Line 6534: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

6530: ) IS
6531:
6532: l_count NUMBER;
6533: l_party_site_id NUMBER;
6534: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
6535: l_begin_date DATE;
6536: l_dummy VARCHAR2(1);
6537: l_created_by_module VARCHAR2(150);
6538: l_application_id NUMBER;

Line 6542: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

6538: l_application_id NUMBER;
6539: l_status VARCHAR2(1);
6540: l_debug_prefix VARCHAR2(30) := '';
6541: -- Bug 2065191.
6542: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
6543:
6544: BEGIN
6545:
6546: --enable_debug;

Line 6578: FROM HZ_PARTY_SITE_USES

6574: l_application_id,
6575: --BUG 2065191
6576: l_primary_per_type
6577:
6578: FROM HZ_PARTY_SITE_USES
6579: WHERE ROWID = p_rowid;
6580: END IF;
6581:
6582: -------------------------

Line 6759: FROM HZ_PARTY_SITE_USES

6755: then
6756: BEGIN
6757: SELECT 'Y'
6758: INTO l_dummy
6759: FROM HZ_PARTY_SITE_USES
6760: -- Bug 3988537.
6761: WHERE PARTY_SITE_ID = nvl(p_party_site_use_rec.party_site_id,l_party_site_id)
6762: AND SITE_USE_TYPE = nvl(p_party_site_use_rec.site_use_type,l_site_use_type)
6763: AND STATUS = 'A'