DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CONTACT_ROLES_B

Line 8481: FROM okc_rep_contact_roles_b b,

8477: AND imp_contract_id = p_imp_contract_id;
8478:
8479: cursor c_contact_role_exist_csr(p_contact_role_txt varchar2) IS
8480: SELECT b.contact_role_id
8481: FROM okc_rep_contact_roles_b b,
8482: okc_rep_contact_roles_tl tl
8483: WHERE Upper(tl.name) = Upper(p_contact_role_txt)
8484: AND b.contact_role_id = tl.contact_role_id;
8485: