APPS.OKS_AUTO_REMINDER dependencies on HZ_CONTACT_POINTS
Line 1593: FROM hz_contact_points hcp,
1589: modified the below cursor to get billto_email addres
1590: */
1591: CURSOR l_billto_email IS
1592: SELECT hcp.email_address 1593: FROM hz_contact_points hcp, 1594: okc_contacts kc
1595: WHERE hcp.owner_table_id = kc.object1_id1
1596: AND kc.cro_code = 'BILLING'
1597: AND hcp.contact_point_type='EMAIL'