APPS.XNB_CMN_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1555: FROM hz_cust_site_uses_all

1551: SELECT site_use_code,
1552: primary_flag
1553: INTO l_site_use_code,
1554: l_flag
1555: FROM hz_cust_site_uses_all
1556: WHERE site_use_id = l_param_value;
1557:
1558: EXCEPTION
1559:

Line 1580: FROM hz_cust_site_uses_all p,

1576: /* R12 MOAC UPTAKE : ksrikant*/
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

Line 1616: FROM hz_cust_site_uses_all p,

1612: /* R12 MOAC UPTAKE : ksrikant*/
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