APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_BUS_VARIABLES_TL

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

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

Line 547: OKC_BUS_VARIABLES_TL BVT,

543: BVB.PROCEDURE_NAME, -- Added for Bug 5958643
544: BVB.MRV_FLAG, -- MRV Project
545: BVB.CLM_SOURCE -- MRV PROJECT
546: FROM
547: OKC_BUS_VARIABLES_TL BVT,
548: OKC_BUS_VARIABLES_B BVB,
549: OKC_ARTICLE_VARIABLES AAV
550: WHERE BVB.VARIABLE_CODE = BVT.VARIABLE_CODE
551: AND BVB.VARIABLE_CODE = AAV.VARIABLE_CODE