APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on HZ_CUST_SITE_USES_ALL

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

175: WHERE header_id = p_header_id;
176:
177: CURSOR address_cur(p_ship_to_site_use_id IN NUMBER) IS
178: SELECT NVL(cust_acct_site_id, 0) address_id
179: FROM hz_cust_site_uses_all a /* Removed ra_site_uses_all for Bug# 4434287 */
180: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
181: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
182: /*
183: ||Cursor modified by aiyer for the bug 3792765

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

3076: WHERE header_id = p_header_id;
3077:
3078: CURSOR address_cur(p_ship_to_org_id IN NUMBER) IS
3079: SELECT NVL(cust_acct_site_id, 0) address_id
3080: FROM HZ_CUST_SITE_USES_ALL A /*Removed ra_site_uses_all for Bug# 4434287 */
3081: WHERE A.site_use_id = p_ship_to_org_id; /* Modified by Ramananda for removal of SQL LITERALs */
3082: -- WHERE A.site_use_id = NVL(p_ship_to_org_id,0);
3083:
3084: -- to get assesable_value