APPS.HR_US_W2_REP dependencies on FF_ARCHIVE_ITEMS

Line 167: from ff_archive_items fai,

163: if w2_tax_unit_id is not null then
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

Line 181: from ff_archive_items fai,

177: and substr(ltrim(rtrim(fic2.context)),1,w2_jurisdiction_level) = substr(w2_jurisdiction_code,1,w2_jurisdiction_level);
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

Line 193: from ff_archive_items fai,

189: else
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

Line 203: from ff_archive_items fai

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

Line 911: from ff_archive_items fai

907: l_bal_amt number;
908:
909: cursor c_sel is
910: select decode(fai.value, 'Y', 1, 'D', 1, 0)
911: from ff_archive_items fai
912: where fai.context1 = w2_asg_act_id
913: and fai.user_entity_id = l_user_entity_id;
914:
915: BEGIN

Line 1110: ff_archive_items fai,

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
1113: and fdi.user_entity_id = fai.user_entity_id
1114: and fai.context1 = w2_payroll_action_id

Line 1120: p_tax_unit_item ff_archive_items.value%type;

1116: and fai.archive_item_id = faic.archive_item_id
1117: and faic.context_id = fc.context_id
1118: and faic.context = to_char(w2_tax_unit_id);
1119:
1120: p_tax_unit_item ff_archive_items.value%type;
1121:
1122: BEGIN
1123: OPEN c_tax_unit_item;
1124: FETCH c_tax_unit_item INTO p_tax_unit_item;

Line 1194: from ff_archive_items fai,

1190:
1191: cursor c_per_item is
1192: select
1193: fai.value
1194: from ff_archive_items fai,
1195: ff_database_items fdi
1196: where fdi.user_name = w2_per_item
1197: and fdi.user_entity_id = fai.user_entity_id
1198: and fai.context1 = w2_assignment_action_id;

Line 1234: ff_archive_items fai,

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
1236: where fdi.user_name = w2_state_item
1237: and fdi.user_entity_id = fai.user_entity_id
1238: and fai.context1 = w2_payroll_action_id

Line 1602: FF_ARCHIVE_ITEMS fai

1598: CURSOR get_year( cp_action_id number) is
1599:
1600: select fai.value designated_roth_contri
1601: from FF_USER_ENTITIES fue,
1602: FF_ARCHIVE_ITEMS fai
1603: where fai.context1 = cp_action_id
1604: AND fai.user_entity_id = fue.user_entity_id
1605: AND upper(fue.user_entity_name) = 'A_FIRST_YEAR_ROTH_CONTRIB' ;
1606: