DBA Data[Home] [Help]

APPS.OKL_AM_PARTIES_PVT dependencies on OKX_CONTACT_POINTS_V

Line 2343: FROM okx_contact_points_v c

2339: contact_point_details,
2340: c.contact_point_id contact_point_id,
2341: c.email_address email_address,
2342: c.primary_flag primary_flag
2343: FROM okx_contact_points_v c
2344: WHERE c.owner_table_name = cp_owner_table_name
2345: AND c.owner_table_id = cp_owner_table_id
2346: AND c.status = 'A'
2347: AND c.contact_point_type IN ('EMAIL','PHONE');

Line 2682: FROM okx_contact_points_v c

2678: CURSOR l_c_points_csr (cp_object_id VARCHAR2) IS
2679: SELECT c.contact_point_id,
2680: c.email_address,
2681: c.primary_flag
2682: FROM okx_contact_points_v c
2683: WHERE c.contact_point_type = 'EMAIL'
2684: AND c.owner_table_name = 'HZ_PARTIES'
2685: AND c.status = 'A'
2686: AND c.owner_table_id = cp_object_id;