DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HZ_RELATIONSHIPS

Line 815: HZ_RELATIONSHIPS REL,

811: cursor c_delegate is
812: select 1
813:
814: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
815: HZ_RELATIONSHIPS REL,
816: HZ_CUST_ACCOUNTS ROLE_ACCT
817:
818: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
819: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 833: HZ_RELATIONSHIPS REL,

829: cursor c_sponsor is
830: select 1
831:
832: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
833: HZ_RELATIONSHIPS REL,
834: HZ_CUST_ACCOUNTS ROLE_ACCT
835:
836: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
837: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'