APPS.OKS_AUTO_REMINDER dependencies on OKX_CONTACT_POINTS_V

Line 64: FROM okx_contact_points_v

60: p_contactpoint_id NUMBER
61: )
62: IS
63: SELECT email_address
64: FROM okx_contact_points_v
65: WHERE contact_point_id = p_contactpoint_id;
66:
67: l_email_address VARCHAR2 (2000)
68: := okc_api.g_miss_char;

Line 1489: FROM okx_contact_points_v

1485: IS
1486: SELECT phone_area_code ||
1487: '-' ||
1488: phone_number
1489: FROM okx_contact_points_v
1490: WHERE owner_table_id = p_id
1491: AND owner_table_name = 'HZ_PARTIES'
1492: AND contact_point_type = 'PHONE'
1493: AND phone_number IS NOT NULL

Line 1545: FROM okx_contact_points_v

1541: IS
1542: SELECT phone_area_code ||
1543: '-' ||
1544: phone_number
1545: FROM okx_contact_points_v
1546: WHERE owner_table_id = p_id
1547: AND owner_table_name = 'HZ_PARTIES'
1548: AND contact_point_type IN ('PHONE', 'FAX')
1549: AND phone_line_type = 'FAX';