DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2983: FROM hz_cust_site_uses_all hzcsu ,

2979:
2980:
2981: CURSOR c_get_address is
2982: SELECT hzcas.cust_acct_site_id
2983: FROM hz_cust_site_uses_all hzcsu ,
2984: hz_cust_acct_sites_all hzcas
2985: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
2986: AND hzcsu.site_use_id = pn_site_use_id
2987: AND hzcas.cust_account_id = pn_customer_id ;