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 1412: FROM okx_contact_points_v

1408: IS
1409: SELECT phone_area_code ||
1410: '-' ||
1411: phone_number
1412: FROM okx_contact_points_v
1413: WHERE owner_table_id = p_id
1414: AND owner_table_name = 'HZ_PARTIES'
1415: AND contact_point_type = 'PHONE'
1416: AND phone_number IS NOT NULL

Line 1468: FROM okx_contact_points_v

1464: IS
1465: SELECT phone_area_code ||
1466: '-' ||
1467: phone_number
1468: FROM okx_contact_points_v
1469: WHERE owner_table_id = p_id
1470: AND owner_table_name = 'HZ_PARTIES'
1471: AND contact_point_type IN ('PHONE', 'FAX')
1472: AND phone_line_type = 'FAX';