DBA Data[Home] [Help]

APPS.OTA_DELEGATE_BOOKING_API dependencies on HZ_CUST_ACCOUNTS

Line 1744: hz_cust_accounts role_acct

1740: Cursor c_contact_user_id is
1741: select rel.subject_id
1742: from hz_cust_account_roles acct_role,
1743: hz_relationships rel,
1744: hz_cust_accounts role_acct
1745: where acct_role.party_id = rel.party_id
1746: and acct_role.role_type = 'CONTACT'
1747: and acct_role.cust_account_id = role_acct.cust_account_id
1748: and role_acct.party_id = rel.object_id