DBA Data[Home] [Help]

APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 611: hz_cust_account_roles hzc

607: SELECT hzp.party_id,
608: hzp.party_name contact_name,
609: hzp.email_address email
610: FROM hz_parties hzp,
611: hz_cust_account_roles hzc
612: WHERE hzc.cust_account_id = p_cust_account_id
613: AND hzc.status = 'A'
614: AND hzc.role_type = 'CONTACT'
615: AND hzc.party_id = hzp.party_id