APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_LOCALIZED_TEXTS

Line 5245: FROM cz_localized_texts

5241: AND variable_value is not null;
5242:
5243: CURSOR csr_translated_value(p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
5244: SELECT localized_str translated_value
5245: FROM cz_localized_texts
5246: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
5247: AND LANGUAGE = USERENV('LANG');
5248:
5249:

Line 5355: FROM cz_localized_texts

5351: AND variable_value is not null;
5352:
5353: CURSOR csr_translated_value(p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
5354: SELECT localized_str translated_value
5355: FROM cz_localized_texts
5356: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
5357: AND LANGUAGE = USERENV('LANG');
5358:
5359: --Bug 4757962 cursor to fetch value for a given question id

Line 5364: cz_localized_texts ltxt

5360: CURSOR csr_get_rule_qst_values (l_config_header_id number, l_config_rev_nbr number) is
5361: SELECT ltxt.localized_str question_value
5362: FROM cz_config_items_v config,
5363: cz_ps_nodes psn,
5364: cz_localized_texts ltxt
5365: WHERE config.config_hdr_id = l_config_header_id
5366: AND config.config_rev_nbr = l_config_rev_nbr
5367: AND config.ps_node_id = psn.ps_node_id
5368: AND psn.intl_text_id = ltxt.intl_text_id

Line 7491: FROM cz_localized_texts

7487: --AND line_number = p_line_number;
7488:
7489: CURSOR l_get_translated_values_csr (p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
7490: SELECT localized_str translated_value
7491: FROM cz_localized_texts
7492: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
7493: AND LANGUAGE = USERENV('LANG');
7494: BEGIN
7495:

Line 7653: cz_localized_texts ltxt

7649: CURSOR l_get_rule_qst_values_csr(p_config_header_id NUMBER, p_config_rev_nbr NUMBER, p_question_id NUMBER) IS
7650: SELECT ltxt.localized_str question_value
7651: FROM cz_config_items_v config,
7652: cz_ps_nodes psn,
7653: cz_localized_texts ltxt
7654: WHERE config.config_hdr_id = p_config_header_id
7655: AND config.config_rev_nbr = p_config_rev_nbr
7656: AND config.ps_node_id = psn.ps_node_id
7657: AND psn.intl_text_id = ltxt.intl_text_id