APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_PARTY_SITES

Line 1380: ,HZ_PARTY_SITES PS

1376: CURSOR l_address_csr
1377: IS
1378: SELECT CS.SITE_USE_ID ID1
1379: FROM HZ_CUST_SITE_USES_all CS
1380: ,HZ_PARTY_SITES PS
1381: ,HZ_CUST_ACCT_SITES_ALL CA
1382: WHERE PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1383: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1384: And Ps.party_id = p_party_id