APPS.OE_EXT_CREDIT_EXPOSURE_PVT dependencies on OE_INVOICE_TO_ORGS_V

Line 156: FROM OE_INVOICE_TO_ORGS_V

152: IS
153:
154: CURSOR c_bill_to_site_use_id (p_bill_to_state VARCHAR2) IS
155: SELECT ORGANIZATION_ID
156: FROM OE_INVOICE_TO_ORGS_V
157: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
159: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 178: FROM OE_INVOICE_TO_ORGS_V

174: and address_status='A'; --2752321
175:
176: CURSOR C1 (p_bill_to_state VARCHAR2) IS
177: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
178: FROM OE_INVOICE_TO_ORGS_V
179: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
180: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
181: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
182: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 208: FROM OE_INVOICE_TO_ORGS_V

204: AND bill_to_flag = 'Y');
205:
206: CURSOR C2 (p_bill_to_state VARCHAR2) IS
207: SELECT ORGANIZATION_ID
208: FROM OE_INVOICE_TO_ORGS_V
209: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
210: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
211: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
212: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 276: FROM OE_INVOICE_TO_ORGS_V

272: RETURN l_bill_to_site_use_id;
273: ELSE
274: SELECT ORGANIZATION_ID
275: INTO l_bill_to_site_use_id
276: FROM OE_INVOICE_TO_ORGS_V
277: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
278: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
279: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
280: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 318: FROM OE_INVOICE_TO_ORGS_V

314: oe_debug_pub.add('org='||l_org, 5);*/
315: --MOAC Changes
316: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
317: INTO l_bill_to_site_use_id
318: FROM OE_INVOICE_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 362: FROM OE_INVOICE_TO_ORGS_V

358: RETURN l_bill_to_site_use_id;
359: ELSE
360: SELECT ORGANIZATION_ID
361: INTO l_bill_to_site_use_id
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_exposure_rec.bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_exposure_rec.bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 493: FROM oe_invoice_to_orgs_v

489: SELECT organization_id,
490: customer_id
491: INTO l_bill_to_site_use_id,
492: l_bill_to_customer_id
493: FROM oe_invoice_to_orgs_v
494: WHERE site_use_id=p_exposure_rec.bill_to_site_use_id;
495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN