DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on HZ_PARTY_SITES_V

Line 3142: from hz_party_sites_v hp,

3138: CURSOR c_primary_account_address(p_party_id NUMBER, p_account_id NUMBER, p_org_id NUMBER, p_site_use_type VARCHAR2)
3139: IS
3140: select distinct
3141: hp.party_site_id
3142: from hz_party_sites_v hp,
3143: hz_parties hz,
3144: hz_cust_acct_sites_all hca,
3145: hz_cust_site_uses_all hcsu
3146: where hcsu.site_use_code = p_site_use_type