[Home] [Help]
100:
101: CURSOR address_cur ( p_ship_to_site_use_id IN NUMBER )
102: IS
103: SELECT NVL(cust_acct_site_id , 0) address_id
104: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
105: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
106: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
107:
108: /*