APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 503: TYPE l_variable_name IS TABLE OF OKC_BUS_VARIABLES_TL.variable_name%TYPE INDEX BY BINARY_INTEGER ;

499: l_earlier_local_version_id NUMBER := 0; -- not used just for check_adoption_details
500: l_dummy_num NUMBER := 0;
501: l_dummy_char VARCHAR2(1) := '?';
502:
503: TYPE l_variable_name IS TABLE OF OKC_BUS_VARIABLES_TL.variable_name%TYPE INDEX BY BINARY_INTEGER ;
504: TYPE l_disabled_yn IS TABLE OF OKC_BUS_VARIABLES_B.disabled_yn%TYPE INDEX BY BINARY_INTEGER ;
505: TYPE l_value_set_id IS TABLE OF OKC_BUS_VARIABLES_B.value_set_id%TYPE INDEX BY BINARY_INTEGER ;
506: TYPE l_variable_type IS TABLE OF OKC_BUS_VARIABLES_B.variable_type%TYPE INDEX BY BINARY_INTEGER ;
507: -- Below Added for bug 5958643

Line 535: OKC_BUS_VARIABLES_TL BVT,

531: BVB.VARIABLE_TYPE,
532: BVB.VARIABLE_SOURCE, -- Added for Bug 5958643
533: BVB.PROCEDURE_NAME -- Added for Bug 5958643
534: FROM
535: OKC_BUS_VARIABLES_TL BVT,
536: OKC_BUS_VARIABLES_B BVB,
537: OKC_ARTICLE_VARIABLES AAV
538: WHERE BVB.VARIABLE_CODE = BVT.VARIABLE_CODE
539: AND BVB.VARIABLE_CODE = AAV.VARIABLE_CODE