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 394: FROM APPS.hz_contact_points

390:
391: FOR cp1 IN (
392: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
393: ' ' || EMAIL_ADDRESS || ' ' phone
394: FROM APPS.hz_contact_points
395: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
396: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
397: AND OWNER_TABLE_ID = l_party_id)
398: LOOP

Line 419: FROM APPS.hz_contact_points

415:
416: FOR cp1 IN (
417: SELECT PHONE_NUMBER||phone_area_code||phone_country_code||
418: ' ' || EMAIL_ADDRESS || ' ' phone
419: FROM APPS.hz_contact_points
420: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
421: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'WEB')
422: AND OWNER_TABLE_ID = cont.rel_party_id)
423: LOOP

Line 431: FROM APPS.hz_contact_points

427: */
428:
429: FOR cp1 IN (
430: SELECT PHONE_NUMBER||phone_area_code||phone_country_code|| ' ' phone
431: FROM APPS.hz_contact_points
432: WHERE OWNER_TABLE_NAME = 'HZ_PARTY_SITES'
433: AND CONTACT_POINT_TYPE NOT IN ( 'EDI', 'EMAIL', 'WEB')
434: AND OWNER_TABLE_ID = sites.party_site_id)
435: LOOP