DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on HZ_PARTY_SITES_V

Line 3185: from hz_party_sites_v hp,

3181: CURSOR c_primary_account_address(p_party_id NUMBER, p_account_id NUMBER, p_org_id NUMBER, p_site_use_type VARCHAR2)
3182: IS
3183: select distinct
3184: hp.party_site_id
3185: from hz_party_sites_v hp,
3186: hz_parties hz,
3187: hz_cust_acct_sites_all hca,
3188: hz_cust_site_uses_all hcsu
3189: where hcsu.site_use_code = p_site_use_type