APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 19: FROM hz_cust_site_uses_all hzcsu ,

15: lv_regno JAI_CMN_CUS_ADDRESSES.vat_Reg_no%type;
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 ;

Line 3344: FROM hz_cust_site_uses_all A /*Removed ra_site_uses_all for Bug# 4434287*/

3340:
3341:
3342: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
3343: SELECT cust_acct_site_id address_id
3344: FROM hz_cust_site_uses_all A /*Removed ra_site_uses_all for Bug# 4434287*/
3345: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
3346: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
3347:
3348: