APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 198: FROM hz_cust_site_uses_all a /* Removed ra_site_uses_all for Bug# 4434287 */

194: WHERE header_id = p_header_id;
195:
196: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
197: SELECT NVL(cust_acct_site_id, 0) address_id
198: FROM hz_cust_site_uses_all a /* Removed ra_site_uses_all for Bug# 4434287 */
199: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
200: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
201: /*
202: ||Cursor modified by aiyer for the bug 3792765

Line 4982: FROM HZ_CUST_SITE_USES_ALL A /*Removed ra_site_uses_all for Bug# 4434287 */

4978: WHERE header_id = p_header_id;
4979:
4980: CURSOR address_cur(p_ship_to_org_id IN NUMBER) IS
4981: SELECT NVL(cust_acct_site_id, 0) address_id
4982: FROM HZ_CUST_SITE_USES_ALL A /*Removed ra_site_uses_all for Bug# 4434287 */
4983: WHERE A.site_use_id = p_ship_to_org_id; /* Modified by Ramananda for removal of SQL LITERALs */
4984: -- WHERE A.site_use_id = NVL(p_ship_to_org_id,0);
4985:
4986: -- to get assesable_value