APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |

43: --| HZ_RELATIONSHIPS | X | | | | | |
44: --+---------------------------------+---+---+---+---+---+----------------------+
45: --| HZ_ORG_CONTACTS | X | | | | | |
46: --+---------------------------------+---+---+---+---+---+----------------------+
47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |
48: --+---------------------------------+---+---+---+---+---+----------------------+
49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |
50: --+---------------------------------+---+---+---+---+---+----------------------+
51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |

Line 1379: FROM HZ_CUST_SITE_USES_all CS

1375: IS
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

Line 1637: FROM hz_cust_site_uses_all a,

1633:
1634: CURSOR l_site_csr
1635: IS
1636: SELECT 'Y'
1637: FROM hz_cust_site_uses_all a,
1638: hz_cust_acct_sites_all b
1639: WHERE a.site_use_id = p_site_use_id
1640: AND a.site_use_code = p_site_use_code
1641: AND a.cust_acct_site_id = b.cust_acct_site_id