APPS.OTA_UTILITY dependencies on HZ_CUST_ACCOUNTS

Line 2340: HZ_CUST_ACCOUNTS ROLE_ACCT

2336: FROM
2337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2338: HZ_PARTIES PARTY,
2339: HZ_RELATIONSHIPS REL,
2340: HZ_CUST_ACCOUNTS ROLE_ACCT
2341: WHERE
2342: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2343: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2344: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 2398: HZ_CUST_ACCOUNTS role_acct

2394: HZ_PARTIES party,
2395: HZ_RELATIONSHIPS rel,
2396: HZ_ORG_CONTACTS org_cont,
2397: HZ_PARTIES rel_party,
2398: HZ_CUST_ACCOUNTS role_acct
2399: where acct_role.party_id = rel.party_id
2400: and acct_role.role_type = 'CONTACT'
2401: and org_cont.party_relationship_id = rel.relationship_id
2402: and rel.subject_id = party.party_id

Line 2436: ,hz_cust_accounts cust_acct

2432:
2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2434: select substrb(party.party_name,1,50)
2435: from hz_parties party
2436: ,hz_cust_accounts cust_acct
2437: where
2438: cust_acct.party_id = party.party_id
2439: and cust_acct.cust_account_id = l_customer_id;
2440:

Line 2754: HZ_CUST_ACCOUNTS role_acct

2750: HZ_PARTIES party,
2751: HZ_RELATIONSHIPS rel,
2752: HZ_ORG_CONTACTS org_cont,
2753: HZ_PARTIES rel_party,
2754: HZ_CUST_ACCOUNTS role_acct
2755: where acct_role.party_id = rel.party_id
2756: and acct_role.role_type = 'CONTACT'
2757: and org_cont.party_relationship_id = rel.relationship_id
2758: and rel.subject_id = party.party_id

Line 3552: HZ_CUST_ACCOUNTS ROLE_ACCT,

3548: SELECT PARTY.EMAIL_ADDRESS
3549: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3550: HZ_PARTIES PARTY,
3551: HZ_RELATIONSHIPS REL,
3552: HZ_CUST_ACCOUNTS ROLE_ACCT,
3553: HZ_ROLE_RESPONSIBILITY ROL ,
3554: HZ_ORG_CONTACTS ORG_CONT,
3555: HZ_LOCATIONS LOC,
3556: HZ_PARTY_SITES PARTY_SITE,