APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_CONTACT_POINTS

Line 290: FROM APPS.hz_contact_points

286:
287: FOR cp1 IN (
288: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
289: ' ' || EMAIL_ADDRESS || ' ' phone
290: FROM APPS.hz_contact_points
291: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
292: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
293: AND OWNER_TABLE_ID = cont.rel_party_id)
294: LOOP

Line 302: FROM APPS.hz_contact_points

298:
299: FOR cp1 IN (
300: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
301: ' ' || EMAIL_ADDRESS || ' ' phone
302: FROM APPS.hz_contact_points
303: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
304: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
305: AND OWNER_TABLE_ID = l_party_id)
306: LOOP

Line 329: FROM APPS.hz_contact_points

325:
326: FOR cp1 IN (
327: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
328: ' ' || EMAIL_ADDRESS || ' ' phone
329: FROM APPS.hz_contact_points
330: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
332: AND OWNER_TABLE_ID = cont.rel_party_id)
333: LOOP

Line 340: FROM APPS.hz_contact_points

336: END LOOP;
337:
338: FOR cp1 IN (
339: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
340: FROM APPS.hz_contact_points
341: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
342: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
343: AND OWNER_TABLE_ID = sites.party_site_id)
344: LOOP

Line 399: FROM APPS.hz_contact_points

395:
396: FOR cp1 IN (
397: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
398: ' ' || EMAIL_ADDRESS || ' ' phone
399: FROM APPS.hz_contact_points
400: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
401: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
402: AND OWNER_TABLE_ID = l_party_id)
403: LOOP

Line 424: FROM APPS.hz_contact_points

420:
421: FOR cp1 IN (
422: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
423: ' ' || EMAIL_ADDRESS || ' ' phone
424: FROM APPS.hz_contact_points
425: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
426: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
427: AND OWNER_TABLE_ID = cont.rel_party_id)
428: LOOP

Line 436: FROM APPS.hz_contact_points

432: */
433:
434: FOR cp1 IN (
435: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
436: FROM APPS.hz_contact_points
437: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
438: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
439: AND OWNER_TABLE_ID = sites.party_site_id)
440: LOOP