DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_PS_NODES

Line 5363: cz_ps_nodes psn,

5359: --Bug 4757962 cursor to fetch value for a given question id
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

Line 7652: cz_ps_nodes psn,

7648:
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