DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 20: hz_cust_acct_sites_all hzcas

16:
17: CURSOR c_get_address is
18: SELECT hzcas.cust_acct_site_id
19: FROM hz_cust_site_uses_all hzcsu ,
20: hz_cust_acct_sites_all hzcas
21: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
22: AND hzcsu.site_use_id = pn_site_use_id
23: AND hzcas.cust_account_id = pn_customer_id ;
24: