APPS.AR_ARXCCS_XMLP_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,

2484: DECODE(AR_PAYMENT_SCHEDULES.EXCHANGE_RATE, NULL, '*', ' '))),
2485: AR_CUSTOMER_CALL_TOPICS.CALL_DATE,
2486: ROUND(TRUNC(SYSDATE) - AR_CUSTOMER_CALL_TOPICS.CALL_DATE)
2487: FROM hz_contact_points cont_point,
2488: hz_cust_account_roles car, AR_LOOKUPS LKUPS,
2489: AR_PAYMENT_SCHEDULES, AR_CUSTOMER_CALL_TOPICS, AR_CALL_ACTIONS
2490: --WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID
2491: WHERE AR_CUSTOMER_CALL_TOPICS.CUSTOMER_ID = CUSTOMER_ID_1
2492: --and AR_CUSTOMER_CALL_TOPICS.site_use_id(+) = site_use_id

Line 2768: from hz_cust_account_roles acct_role,

2764: cont_point.phone_area_code || ' ' ||
2765: RTRIM(RPAD(decode(cont_point.contact_point_type,'TLX',
2766: cont_point.telex_number,
2767: cont_point.phone_number), 15))
2768: from hz_cust_account_roles acct_role,
2769: hz_parties party,
2770: hz_relationships rel,
2771: hz_org_contacts org_cont,
2772: hz_contact_points cont_point,

Line 2773: hz_cust_account_roles car

2769: hz_parties party,
2770: hz_relationships rel,
2771: hz_org_contacts org_cont,
2772: hz_contact_points cont_point,
2773: hz_cust_account_roles car
2774: where acct_role.cust_acct_site_id = Address_id
2775: and acct_role.party_id = rel.party_id
2776: and acct_role.role_type = 'CONTACT'
2777: and org_cont.party_relationship_id = rel.relationship_id