DBA Data[Home] [Help]

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'