APPS.GMI_PIR01_XMLP_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 136: FND_LOOKUP_VALUES_VL

132: IF ORDER1 = '1' THEN
133: SELECT
134: MEANING
135: INTO ORDER2 FROM
136: FND_LOOKUP_VALUES_VL
137: WHERE LOOKUP_CODE = '1'
138: AND LOOKUP_TYPE = 'PI_ORDER';
139: ELSIF ORDER1 = '2' THEN
140: SELECT

Line 144: FND_LOOKUP_VALUES_VL

140: SELECT
141: MEANING
142: INTO ORDER2
143: FROM
144: FND_LOOKUP_VALUES_VL
145: WHERE LOOKUP_CODE = '2'
146: AND LOOKUP_TYPE = 'PI_ORDER';
147: END IF;
148: RETURN (ORDER2);

Line 158: FND_LOOKUP_VALUES_VL

154: SELECT
155: MEANING
156: INTO SORT1
157: FROM
158: FND_LOOKUP_VALUES_VL
159: WHERE LOOKUP_CODE = '1'
160: AND LOOKUP_TYPE = 'PI_PIR01_SORT';
161: ELSIF SORT_BY = '2' THEN
162: SELECT

Line 166: FND_LOOKUP_VALUES_VL

162: SELECT
163: MEANING
164: INTO SORT1
165: FROM
166: FND_LOOKUP_VALUES_VL
167: WHERE LOOKUP_CODE = '2'
168: AND LOOKUP_TYPE = 'PI_PIR01_SORT';
169: END IF;
170: RETURN (SORT1);

Line 180: FND_LOOKUP_VALUES_VL

176: SELECT
177: MEANING
178: INTO SELECT1
179: FROM
180: FND_LOOKUP_VALUES_VL
181: WHERE LOOKUP_CODE = '1'
182: AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';
183: ELSIF SELECT_CRITERIA = '2' THEN
184: SELECT

Line 188: FND_LOOKUP_VALUES_VL

184: SELECT
185: MEANING
186: INTO SELECT1
187: FROM
188: FND_LOOKUP_VALUES_VL
189: WHERE LOOKUP_CODE = '2'
190: AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';
191: ELSIF SELECT_CRITERIA = '3' THEN
192: SELECT

Line 196: FND_LOOKUP_VALUES_VL

192: SELECT
193: MEANING
194: INTO SELECT1
195: FROM
196: FND_LOOKUP_VALUES_VL
197: WHERE LOOKUP_CODE = '3'
198: AND LOOKUP_TYPE = 'PI_SELECTCRITERIA';
199: END IF;
200: RETURN (SELECT1);