APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 274: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

270:
271: FOR cont in (
272: SELECT rel.PARTY_ID rel_party_id,
273: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
274: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
275: APPS.HZ_RELATIONSHIPS rel
276: WHERE ar.cust_account_id = sites.cust_account_id
277: AND (ar.cust_acct_site_id is null)
278: AND ar.ROLE_TYPE = 'CONTACT'

Line 313: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

309:
310: FOR cont in (
311: SELECT rel.PARTY_ID rel_party_id,
312: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
313: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
314: APPS.HZ_RELATIONSHIPS rel
315: WHERE ar.cust_account_id = sites.cust_account_id
316: AND (ar.cust_acct_site_id = sites.cust_acct_site_id)
317: AND ar.ROLE_TYPE = 'CONTACT'

Line 411: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,

407: /*
408: FOR cont in (
409: SELECT rel.PARTY_ID rel_party_id,
410: p.PERSON_FIRST_NAME || ' ' || p.PERSON_LAST_NAME|| ' ' name
411: FROM APPS.HZ_PARTIES p, APPS.HZ_CUST_ACCOUNT_ROLES ar,
412: APPS.HZ_PARTY_RELATIONSHIPS rel
413: WHERE ar.cust_account_id = sites.cust_account_id
414: AND (ar.cust_acct_site_id = sites.cust_acct_site_id)
415: AND ar.ROLE_TYPE = 'CONTACT'