DBA Data[Home] [Help]

APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 565: hz_cust_account_roles hzc

561: SELECT hzp.party_id,
562: hzp.party_name contact_name,
563: hzp.email_address email
564: FROM hz_parties hzp,
565: hz_cust_account_roles hzc
566: WHERE hzc.cust_account_id = p_cust_account_id
567: AND hzc.status = 'A'
568: AND hzc.role_type = 'CONTACT'
569: AND hzc.party_id = hzp.party_id