DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_PS_NODES

Line 5165: cz_ps_nodes psn,

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

Line 7369: cz_ps_nodes psn,

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