APPS.HR_US_W2_REP dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 174: ff_archive_item_contexts fic1,

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
177: and fai.user_entity_id = l_user_entity_id
178: and fai.archive_item_id = fic1.archive_item_id

Line 175: ff_archive_item_contexts fic2

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
177: and fai.user_entity_id = l_user_entity_id
178: and fai.archive_item_id = fic1.archive_item_id
179: and fic1.context_id = l_tax_context_id

Line 188: ff_archive_item_contexts fic

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
191: and fai.archive_item_id = fic.archive_item_id
192: and fic.context_id = l_tax_context_id

Line 200: ff_archive_item_contexts fic

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
203: and fai.archive_item_id = fic.archive_item_id
204: and fic.context_id = l_jd_context_id

Line 1223: from ff_archive_item_contexts faic,

1219: w2_tax_unit_item varchar2) RETURN VARCHAR2 is
1220:
1221: CURSOR c_tax_unit_item IS
1222: select fai.value
1223: from ff_archive_item_contexts faic,
1224: ff_contexts fc,
1225: ff_archive_items fai,
1226: ff_database_items fdi
1227: where fdi.user_name = w2_tax_unit_item

Line 1345: ff_archive_item_contexts faic2,

1341: cursor c_state_item is
1342: select
1343: fai.value
1344: from
1345: ff_archive_item_contexts faic2,
1346: ff_archive_item_contexts faic1,
1347: ff_contexts fc2,
1348: ff_contexts fc1,
1349: ff_archive_items fai,

Line 1346: ff_archive_item_contexts faic1,

1342: select
1343: fai.value
1344: from
1345: ff_archive_item_contexts faic2,
1346: ff_archive_item_contexts faic1,
1347: ff_contexts fc2,
1348: ff_contexts fc1,
1349: ff_archive_items fai,
1350: ff_database_items fdi