APPS.HR_US_W2_REP dependencies on FND_NUMBER

Line 172: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt

168:
169: if w2_tax_unit_id is not null then
170: if w2_jurisdiction_code <> '00-000-0000' then
171: --dbms_output.put_line('got jd and gre as not null ');
172: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
173: from ff_archive_items fai,
174: ff_archive_item_contexts fic1,
175: ff_archive_item_contexts fic2
176: where fai.context1 = w2_asg_act_id

Line 186: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt

182: and fic2.context_id = l_jd_context_id
183: and substr(ltrim(rtrim(fic2.context)),1,w2_jurisdiction_level) = substr(w2_jurisdiction_code,1,w2_jurisdiction_level);
184: else
185: --dbms_output.put_line('got jd as null and gre as not null ');
186: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
187: from ff_archive_items fai,
188: ff_archive_item_contexts fic
189: where fai.context1 = w2_asg_act_id
190: and fai.user_entity_id = l_user_entity_id

Line 198: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt

194: end if;
195: else
196: if w2_jurisdiction_code <> '00-000-0000' then
197: --dbms_output.put_line('got jd as not null and gre as null ');
198: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
199: from ff_archive_items fai,
200: ff_archive_item_contexts fic
201: where fai.context1 = w2_asg_act_id
202: and fai.user_entity_id = l_user_entity_id

Line 208: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt

204: and fic.context_id = l_jd_context_id
205: and substr(ltrim(rtrim(fic.context)),1,w2_jurisdiction_level) = substr(w2_jurisdiction_code,1,w2_jurisdiction_level);
206: else
207: --dbms_output.put_line('got jd and gre as null ');
208: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
209: from ff_archive_items fai
210: where fai.context1 = w2_asg_act_id
211: and fai.user_entity_id = l_user_entity_id;
212: end if;