DBA Data[Home] [Help]

APPS.OTA_TDB_BUS dependencies on HZ_RELATIONSHIPS

Line 463: HZ_RELATIONSHIPS REL,

459: cursor c_external is
460: select 1
461:
462: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
463: HZ_RELATIONSHIPS REL,
464: HZ_CUST_ACCOUNTS ROLE_ACCT
465:
466: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
467: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 1815: HZ_RELATIONSHIPS rel,

1811: Cursor c_party is
1812: SELECT party.party_id
1813: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
1814: HZ_PARTIES party,
1815: HZ_RELATIONSHIPS rel,
1816: HZ_ORG_CONTACTS org_cont,
1817: HZ_PARTIES rel_party,
1818: HZ_CUST_ACCOUNTS role_acct
1819: WHERE acct_role.party_id = rel.party_id