DBA Data[Home] [Help]

APPS.PA_PAXPRCON_XMLP_PKG dependencies on FND_LOOKUPS

Line 181: FROM fnd_lookups

177: tmp_over_flag VARCHAR2(80);
178: begin
179: IF baseline_funding_flag IS NOT NULL THEN
180: SELECT meaning INTO tmp_over_flag
181: FROM fnd_lookups
182: WHERE lookup_type = 'YES_NO' AND lookup_code = baseline_funding_flag ;
183: RETURN tmp_over_flag;
184: ELSE
185: RETURN NULL;

Line 196: FROM fnd_lookups

192: tmp_over_flag VARCHAR2(80);
193: begin
194: IF revaluate_funding_flag IS NOT NULL THEN
195: SELECT meaning INTO tmp_over_flag
196: FROM fnd_lookups
197: WHERE lookup_type = 'YES_NO' AND lookup_code = revaluate_funding_flag ;
198: RETURN tmp_over_flag;
199: ELSE
200: RETURN NULL;

Line 211: FROM fnd_lookups

207: tmp_over_flag VARCHAR2(80);
208: begin
209: IF include_gains_losses_flag IS NOT NULL THEN
210: SELECT meaning INTO tmp_over_flag
211: FROM fnd_lookups
212: WHERE lookup_type = 'YES_NO' AND lookup_code = include_gains_losses_flag ;
213: RETURN tmp_over_flag;
214: ELSE
215: RETURN NULL;