DBA Data[Home] [Help]

APPS.OKS_AUTO_REMINDER dependencies on HZ_CONTACT_POINTS

Line 1516: FROM hz_contact_points hcp,

1512: modified the below cursor to get billto_email addres
1513: */
1514: CURSOR l_billto_email IS
1515: SELECT hcp.email_address
1516: FROM hz_contact_points hcp,
1517: okc_contacts kc
1518: WHERE hcp.owner_table_id = kc.object1_id1
1519: AND kc.cro_code = 'BILLING'
1520: AND hcp.contact_point_type='EMAIL'