APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_CONTACT_ROLES_TL

Line 4135: FROM okc_rep_contact_roles_tl

4131: AND UPPER(MEANING) = UPPER(p_overall_risk_txt);
4132:
4133: CURSOR notify_role_csr(p_notify_contact_role_txt VARCHAR2) IS
4134: SELECT contact_role_id
4135: FROM okc_rep_contact_roles_tl
4136: WHERE Upper(name) = Upper(p_notify_contact_role_txt)
4137: AND LANGUAGE = userenv('LANG');
4138:
4139:

Line 8482: okc_rep_contact_roles_tl tl

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:
8486: BEGIN