APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_LOCALIZED_TEXTS

Line 5047: FROM cz_localized_texts

5043: AND variable_value is not null;
5044:
5045: CURSOR csr_translated_value(p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
5046: SELECT localized_str translated_value
5047: FROM cz_localized_texts
5048: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
5049: AND LANGUAGE = USERENV('LANG');
5050:
5051:

Line 5157: FROM cz_localized_texts

5153: AND variable_value is not null;
5154:
5155: CURSOR csr_translated_value(p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
5156: SELECT localized_str translated_value
5157: FROM cz_localized_texts
5158: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
5159: AND LANGUAGE = USERENV('LANG');
5160:
5161: --Bug 4757962 cursor to fetch value for a given question id

Line 5166: cz_localized_texts ltxt

5162: CURSOR csr_get_rule_qst_values (l_config_header_id number, l_config_rev_nbr number) is
5163: SELECT ltxt.localized_str question_value
5164: FROM cz_config_items_v config,
5165: cz_ps_nodes psn,
5166: cz_localized_texts ltxt
5167: WHERE config.config_hdr_id = l_config_header_id
5168: AND config.config_rev_nbr = l_config_rev_nbr
5169: AND config.ps_node_id = psn.ps_node_id
5170: AND psn.intl_text_id = ltxt.intl_text_id

Line 7208: FROM cz_localized_texts

7204: --AND line_number = p_line_number;
7205:
7206: CURSOR l_get_translated_values_csr (p_variable_id VARCHAR2, p_variable_value VARCHAR2) IS
7207: SELECT localized_str translated_value
7208: FROM cz_localized_texts
7209: WHERE orig_sys_ref LIKE 'OKC:VARIABLEMODELOPTION:-99:%:' || p_variable_id || ':' || p_variable_value
7210: AND LANGUAGE = USERENV('LANG');
7211: BEGIN
7212:

Line 7370: cz_localized_texts ltxt

7366: CURSOR l_get_rule_qst_values_csr(p_config_header_id NUMBER, p_config_rev_nbr NUMBER, p_question_id NUMBER) IS
7367: SELECT ltxt.localized_str question_value
7368: FROM cz_config_items_v config,
7369: cz_ps_nodes psn,
7370: cz_localized_texts ltxt
7371: WHERE config.config_hdr_id = p_config_header_id
7372: AND config.config_rev_nbr = p_config_rev_nbr
7373: AND config.ps_node_id = psn.ps_node_id
7374: AND psn.intl_text_id = ltxt.intl_text_id