[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