APPS.XNB_CMN_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1581: hz_cust_acct_sites_all a,

1577:
1578: SELECT b.account_number
1579: INTO l_account_number
1580: FROM hz_cust_site_uses_all p,
1581: hz_cust_acct_sites_all a,
1582: hz_cust_accounts b
1583: WHERE p.site_use_id = l_param_value
1584: AND a.cust_acct_site_id = p.cust_acct_site_id
1585: AND a.cust_account_id = b.cust_account_id;

Line 1617: hz_cust_acct_sites_all a,

1613:
1614: SELECT b.account_number
1615: INTO l_account_number
1616: FROM hz_cust_site_uses_all p,
1617: hz_cust_acct_sites_all a,
1618: hz_cust_accounts b
1619: WHERE p.site_use_id = l_param_value
1620: AND a.cust_acct_site_id = p.cust_acct_site_id
1621: AND a.cust_account_id = b.cust_account_id;