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 1375: FROM HZ_CUST_SITE_USES_all CS

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

Line 1633: FROM hz_cust_site_uses_all a,

1629:
1630: CURSOR l_site_csr
1631: IS
1632: SELECT 'Y'
1633: FROM hz_cust_site_uses_all a,
1634: hz_cust_acct_sites_all b
1635: WHERE a.site_use_id = p_site_use_id
1636: AND a.site_use_code = p_site_use_code
1637: AND a.cust_acct_site_id = b.cust_acct_site_id