APPS.PA_PAXRWPTY_XMLP_PKG dependencies on FND_LOOKUPS

Line 196: SELECT SUBSTR(meaning,1,40) INTO temp_yesno FROM fnd_lookups

192: function cf_burden_acc_flagformula(burden_account_flag in varchar2) return varchar2 is
193: temp_yesno VARCHAR2(40) :=null;
194: begin
195: IF burden_account_flag IS NOT NULL THEN
196: SELECT SUBSTR(meaning,1,40) INTO temp_yesno FROM fnd_lookups
197: WHERE lookup_type = 'YES_NO' AND lookup_code = burden_account_flag;
198: END IF;
199: RETURN temp_yesno ;
200: end;

Line 231: select meaning into l_meaning from fnd_lookups

227: function cf_baseline_fiunding_flagformu(baseline_funding_flag in varchar2) return char is
228: l_meaning varchar2(40):=NULL;
229: begin
230: if baseline_funding_flag IS NOT NULL then
231: select meaning into l_meaning from fnd_lookups
232: where lookup_type='YES_NO'
233: and lookup_code=baseline_funding_flag;
234: end if;
235: return l_meaning;

Line 242: select meaning into l_meaning from fnd_lookups

238: function cf_revaluate_funding_flagformu(revaluate_funding_flag in varchar2) return char is
239: l_meaning varchar2(40):=NULL;
240: begin
241: if revaluate_funding_flag IS NOT NULL then
242: select meaning into l_meaning from fnd_lookups
243: where lookup_type='YES_NO'
244: and lookup_code=revaluate_funding_flag;
245: end if;
246: return l_meaning;

Line 253: select meaning into l_meaning from fnd_lookups

249: function cf_include_gains_losses_flagfo(include_gains_losses_flag in varchar2) return char is
250: l_meaning varchar2(40):=NULL;
251: begin
252: if include_gains_losses_flag IS NOT NULL then
253: select meaning into l_meaning from fnd_lookups
254: where lookup_type='YES_NO'
255: and lookup_code=include_gains_losses_flag;
256: end if;
257: return l_meaning;