eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AUTO_INSURANCE_PVT dependencies on HZ_CONTACT_POINTS

Line 381: hz_contact_points hcp_email

377: -- Cursor to get Email Id
378: CURSOR get_email (p_cust_acct_id NUMBER) IS
379: SELECT hcp_email.email_address
380: FROM hz_cust_account_roles hcar ,
381: hz_contact_points hcp_email
382: WHERE hcar.cust_account_id = p_cust_acct_id
383: AND hcar.cust_acct_site_id IS NULL
384: AND hcar.status = 'A'
385: AND hcar.role_type = 'CONTACT'

Line 753: hz_contact_points hcp_email

749: -- Cursor to get Email Id
750: CURSOR get_email (p_cust_acct_id NUMBER) IS
751: SELECT hcp_email.email_address
752: FROM hz_cust_account_roles hcar ,
753: hz_contact_points hcp_email
754: WHERE hcar.cust_account_id = p_cust_acct_id
755: AND hcar.cust_acct_site_id IS NULL
756: AND hcar.status = 'A'
757: AND hcar.role_type = 'CONTACT'