APPS.PA_PAXRWIMP_XMLP_PKG dependencies on FND_LOOKUPS

Line 92: FROM fnd_lookups

88: tmp_over_flag VARCHAR2(80);
89: begin
90: IF overtime_flag IS NOT NULL THEN
91: SELECT meaning INTO tmp_over_flag
92: FROM fnd_lookups
93: WHERE lookup_type = 'YES_NO' AND lookup_code = overtime_flag ;
94: RETURN tmp_over_flag;
95: ELSE
96: RETURN NULL;

Line 108: FROM fnd_lookups

104: tmp_labortogl VARCHAR2(80);
105: begin
106: IF Iflabortogl IS NOT NULL THEN
107: SELECT meaning INTO tmp_labortogl
108: FROM fnd_lookups
109: WHERE lookup_type = 'YES_NO' AND lookup_code = Iflabortogl ;
110: RETURN tmp_labortogl;
111: ELSE
112: RETURN NULL;

Line 124: FROM fnd_lookups

120: tmp_ifrevtogl VARCHAR2(80);
121: begin
122: IF Ifrevenuetogl IS NOT NULL THEN
123: SELECT meaning INTO tmp_ifrevtogl
124: FROM fnd_lookups
125: WHERE lookup_type = 'YES_NO' AND lookup_code = ifrevenuetogl ;
126: RETURN tmp_ifrevtogl;
127: ELSE
128: RETURN NULL;

Line 140: FROM fnd_lookups

136: tmp_ifusgtogl VARCHAR2(80);
137: begin
138: IF ifusagetogl IS NOT NULL THEN
139: SELECT meaning INTO tmp_ifusgtogl
140: FROM fnd_lookups
141: WHERE lookup_type = 'YES_NO' AND lookup_code = ifusagetogl ;
142: RETURN tmp_ifusgtogl;
143: ELSE
144: RETURN NULL;

Line 156: FROM fnd_lookups

152: tmp_ceninvcoll VARCHAR2(80);
153: begin
154: IF centralized_invoicing_flag IS NOT NULL THEN
155: SELECT meaning INTO tmp_ceninvcoll
156: FROM fnd_lookups
157: WHERE lookup_type = 'YES_NO' AND lookup_code =
158: centralized_invoicing_flag ;
159: RETURN tmp_ceninvcoll;
160: ELSE

Line 173: FROM fnd_lookups

169: tmp_ifretnacc VARCHAR2(80);
170: begin
171: IF Ifretnacc IS NOT NULL THEN
172: SELECT meaning INTO tmp_ifretnacc
173: FROM fnd_lookups
174: WHERE lookup_type = 'YES_NO' AND lookup_code = ifretnacc ;
175: RETURN tmp_ifretnacc;
176: ELSE
177: RETURN NULL;

Line 189: FROM fnd_lookups

185: tmp_over_flag VARCHAR2(80);
186: begin
187: IF mrc_for_fund IS NOT NULL THEN
188: SELECT meaning INTO tmp_over_flag
189: FROM fnd_lookups
190: WHERE lookup_type = 'YES_NO'
191: AND lookup_code = DECODE(mrc_for_fund,'U','Y', mrc_for_fund);
192: RETURN tmp_over_flag;
193: ELSE

Line 206: FROM fnd_lookups

202: tmp_over_flag VARCHAR2(80);
203: begin
204: IF reval_mrc_fund IS NOT NULL THEN
205: SELECT meaning INTO tmp_over_flag
206: FROM fnd_lookups
207: WHERE lookup_type = 'YES_NO'
208: AND lookup_code = DECODE(reval_mrc_fund,'U','Y', reval_mrc_fund);
209: RETURN tmp_over_flag;
210: ELSE

Line 223: FROM fnd_lookups

219: tmp_over_flag VARCHAR2(80);
220: begin
221: IF mrc_for_finplan IS NOT NULL THEN
222: SELECT meaning INTO tmp_over_flag
223: FROM fnd_lookups
224: WHERE lookup_type = 'YES_NO'
225: AND lookup_code = DECODE(mrc_for_finplan,'U','Y', mrc_for_finplan) ;
226: RETURN tmp_over_flag;
227: ELSE

Line 240: FROM fnd_lookups

236: tmp_over_flag VARCHAR2(80);
237: begin
238: IF ingainloss IS NOT NULL THEN
239: SELECT meaning INTO tmp_over_flag
240: FROM fnd_lookups
241: WHERE lookup_type = 'YES_NO' AND lookup_code = ingainloss ;
242: RETURN tmp_over_flag;
243: ELSE
244: RETURN NULL;

Line 290: temp fnd_lookups.meaning%TYPE;

286:
287:
288:
289: function cf_credit_memoformula(credit_memo_reason_flag in varchar2) return char is
290: temp fnd_lookups.meaning%TYPE;
291: begin
292: IF credit_memo_reason_flag IS NOT NULL THEN
293: SELECT meaning
294: INTO temp

Line 295: FROM fnd_lookups

291: begin
292: IF credit_memo_reason_flag IS NOT NULL THEN
293: SELECT meaning
294: INTO temp
295: FROM fnd_lookups
296: WHERE lookup_type = 'YES_NO'
297: AND lookup_code = credit_memo_reason_flag;
298: END IF;
299: