APPS.HR_US_W2_REP dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 168: ff_archive_item_contexts fic1,

164: if w2_jurisdiction_code <> '00-000-0000' then
165: --dbms_output.put_line('got jd and gre as not null ');
166: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
167: from ff_archive_items fai,
168: ff_archive_item_contexts fic1,
169: ff_archive_item_contexts fic2
170: where fai.context1 = w2_asg_act_id
171: and fai.user_entity_id = l_user_entity_id
172: and fai.archive_item_id = fic1.archive_item_id

Line 169: ff_archive_item_contexts fic2

165: --dbms_output.put_line('got jd and gre as not null ');
166: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
167: from ff_archive_items fai,
168: ff_archive_item_contexts fic1,
169: ff_archive_item_contexts fic2
170: where fai.context1 = w2_asg_act_id
171: and fai.user_entity_id = l_user_entity_id
172: and fai.archive_item_id = fic1.archive_item_id
173: and fic1.context_id = l_tax_context_id

Line 182: ff_archive_item_contexts fic

178: else
179: --dbms_output.put_line('got jd as null and gre as not null ');
180: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
181: from ff_archive_items fai,
182: ff_archive_item_contexts fic
183: where fai.context1 = w2_asg_act_id
184: and fai.user_entity_id = l_user_entity_id
185: and fai.archive_item_id = fic.archive_item_id
186: and fic.context_id = l_tax_context_id

Line 194: ff_archive_item_contexts fic

190: if w2_jurisdiction_code <> '00-000-0000' then
191: --dbms_output.put_line('got jd as not null and gre as null ');
192: select nvl(fnd_number.canonical_to_number(fai.value),0) into l_bal_amt
193: from ff_archive_items fai,
194: ff_archive_item_contexts fic
195: where fai.context1 = w2_asg_act_id
196: and fai.user_entity_id = l_user_entity_id
197: and fai.archive_item_id = fic.archive_item_id
198: and fic.context_id = l_jd_context_id

Line 1108: from ff_archive_item_contexts faic,

1104: w2_tax_unit_item varchar2) RETURN VARCHAR2 is
1105:
1106: CURSOR c_tax_unit_item IS
1107: select fai.value
1108: from ff_archive_item_contexts faic,
1109: ff_contexts fc,
1110: ff_archive_items fai,
1111: ff_database_items fdi
1112: where fdi.user_name = w2_tax_unit_item

Line 1230: ff_archive_item_contexts faic2,

1226: cursor c_state_item is
1227: select
1228: fai.value
1229: from
1230: ff_archive_item_contexts faic2,
1231: ff_archive_item_contexts faic1,
1232: ff_contexts fc2,
1233: ff_contexts fc1,
1234: ff_archive_items fai,

Line 1231: ff_archive_item_contexts faic1,

1227: select
1228: fai.value
1229: from
1230: ff_archive_item_contexts faic2,
1231: ff_archive_item_contexts faic1,
1232: ff_contexts fc2,
1233: ff_contexts fc1,
1234: ff_archive_items fai,
1235: ff_database_items fdi