DBA Data[Home] [Help]

APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_VARIABLES_B

Line 1906: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';

1902: l_int_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
1903: l_perform_int_qa VARCHAR2(1);
1904:
1905: l_variable_value VARCHAR2(2500) := NULL;
1906: l_previous_var_code okc_bus_variables_b.variable_code%TYPE := '-99';
1907: l_return_status VARCHAR2(10);
1908: l_msg_count NUMBER;
1909: l_msg_data VARCHAR2(2500);
1910:

Line 1920: okc_bus_variables_b VB,

1916: KA.scn_id,
1917: VT.variable_name
1918: FROM okc_k_articles_b KA,
1919: okc_k_art_variables KV,
1920: okc_bus_variables_b VB,
1921: okc_bus_variables_tl VT
1922: WHERE VB.variable_code = KV.variable_code
1923: AND KA.id = KV.cat_id
1924: AND VB.variable_code = VT.variable_code