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 2817: FROM hz_cust_site_uses_all A /*Removed ra_site_uses_all for Bug# 4434287*/

2813:
2814:
2815: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
2816: SELECT cust_acct_site_id address_id
2817: FROM hz_cust_site_uses_all A /*Removed ra_site_uses_all for Bug# 4434287*/
2818: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
2819: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
2820:
2821: