APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_PARTY_SITES

Line 1376: ,HZ_PARTY_SITES PS

1372: CURSOR l_address_csr
1373: IS
1374: SELECT CS.SITE_USE_ID ID1
1375: FROM HZ_CUST_SITE_USES_all CS
1376: ,HZ_PARTY_SITES PS
1377: ,HZ_CUST_ACCT_SITES_ALL CA
1378: WHERE PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
1379: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1380: And Ps.party_id = p_party_id