APPS.BNE_LCT_TOOLS_PKG dependencies on BNE_PARAM_LIST_ITEMS

Line 111: FROM BNE_ATTRIBUTES A, BNE_PARAM_LIST_ITEMS I

107: CURSOR C_ATT9(CP_APPLICATION_ID NUMBER,
108: CP_PARAM_LIST_CODE VARCHAR2)
109: IS
110: SELECT ATTRIBUTE9
111: FROM BNE_ATTRIBUTES A, BNE_PARAM_LIST_ITEMS I
112: WHERE A.APPLICATION_ID = I.ATTRIBUTE_APP_ID
113: AND A.ATTRIBUTE_CODE = I.ATTRIBUTE_CODE
114: AND I.APPLICATION_ID = CP_APPLICATION_ID
115: AND I.PARAM_LIST_CODE = CP_PARAM_LIST_CODE

Line 157: FROM BNE_PARAM_LIST_ITEMS

153: SELECT PARAM_NAME,
154: STRING_VALUE,
155: ATTRIBUTE_APP_ID,
156: ATTRIBUTE_CODE
157: FROM BNE_PARAM_LIST_ITEMS
158: WHERE APPLICATION_ID = CP_APPLICATION_ID
159: AND PARAM_LIST_CODE = CP_PARAM_LIST_CODE;
160:
161: PARAM_NAME BNE_PARAM_LIST_ITEMS.PARAM_NAME%TYPE;

Line 161: PARAM_NAME BNE_PARAM_LIST_ITEMS.PARAM_NAME%TYPE;

157: FROM BNE_PARAM_LIST_ITEMS
158: WHERE APPLICATION_ID = CP_APPLICATION_ID
159: AND PARAM_LIST_CODE = CP_PARAM_LIST_CODE;
160:
161: PARAM_NAME BNE_PARAM_LIST_ITEMS.PARAM_NAME%TYPE;
162: PARAM_VALUE BNE_PARAM_LIST_ITEMS.STRING_VALUE%TYPE;
163: COLON_POSITION INTEGER;
164: KEY_NUMBER NUMBER;
165: KEY_CODE VARCHAR2(40);

Line 162: PARAM_VALUE BNE_PARAM_LIST_ITEMS.STRING_VALUE%TYPE;

158: WHERE APPLICATION_ID = CP_APPLICATION_ID
159: AND PARAM_LIST_CODE = CP_PARAM_LIST_CODE;
160:
161: PARAM_NAME BNE_PARAM_LIST_ITEMS.PARAM_NAME%TYPE;
162: PARAM_VALUE BNE_PARAM_LIST_ITEMS.STRING_VALUE%TYPE;
163: COLON_POSITION INTEGER;
164: KEY_NUMBER NUMBER;
165: KEY_CODE VARCHAR2(40);
166: TMP VARCHAR2(2000);

Line 344: FROM BNE_PARAM_LIST_ITEMS LI, BNE_PARAM_DEFNS_B PD, BNE_ATTRIBUTES A

340: CURSOR C_LIST_FK(CP_APPLICATION_ID NUMBER,
341: CP_PARAM_LIST_CODE VARCHAR2)
342: IS
343: SELECT A.*
344: FROM BNE_PARAM_LIST_ITEMS LI, BNE_PARAM_DEFNS_B PD, BNE_ATTRIBUTES A
345: WHERE LI.PARAM_DEFN_APP_ID = PD.APPLICATION_ID
346: AND LI.PARAM_DEFN_CODE = PD.PARAM_DEFN_CODE
347: AND PD.PARAM_SOURCE = 'WEBADI:ViewerExtension'
348: AND A.APPLICATION_ID = PD.ATTRIBUTE_APP_ID