APPS.OZF_WEBADI_INTERFACE_PVT dependencies on HZ_PARTY_SITES

Line 617: hz_party_sites hps

613: FROM hz_cust_accounts hca,
614: hz_parties hp,
615: hz_cust_site_uses hcsu,
616: hz_cust_acct_sites hcas,
617: hz_party_sites hps
618: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
619: AND hcas.party_site_id = hps.party_site_id
620: AND hcsu.status = 'A'
621: AND hps.status = 'A'

Line 909: FROM hz_party_sites

905: WHERE name = 'utl_file_dir';
906:
907: CURSOR csr_get_party_site_id(cv_site_number IN VARCHAR2) IS
908: SELECT party_site_id
909: FROM hz_party_sites
910: WHERE party_site_number = cv_site_number;
911:
912:
913: l_batch_count NUMBER := 0;