[Home] [Help]
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
177: and fai.user_entity_id = l_user_entity_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
191: and fai.archive_item_id = fic.archive_item_id
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
203: and fai.archive_item_id = fic.archive_item_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;
213: end if;
272: AND paa.assignment_action_id = p_assign_action_id;
273:
274: CURSOR check_archive_data (p_assign_action_id NUMBER) IS
275: SELECT 'Y'
276: FROM FF_ARCHIVE_ITEMS FAI,
277: FF_DATABASE_ITEMS FDI
278: WHERE p_assign_action_id = FAI.CONTEXT1
279: AND FAI.USER_ENTITY_ID = FDI.USER_ENTITY_ID
280: AND FDI.USER_NAME IN
1022: l_bal_amt number;
1023:
1024: cursor c_sel is
1025: select decode(fai.value, 'Y', 1, 'D', 1, 0)
1026: from ff_archive_items fai
1027: where fai.context1 = w2_asg_act_id
1028: and fai.user_entity_id = l_user_entity_id;
1029:
1030: BEGIN
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
1228: and fdi.user_entity_id = fai.user_entity_id
1229: and fai.context1 = w2_payroll_action_id
1231: and fai.archive_item_id = faic.archive_item_id
1232: and faic.context_id = fc.context_id
1233: and faic.context = to_char(w2_tax_unit_id);
1234:
1235: p_tax_unit_item ff_archive_items.value%type;
1236:
1237: BEGIN
1238: OPEN c_tax_unit_item;
1239: FETCH c_tax_unit_item INTO p_tax_unit_item;
1305:
1306: cursor c_per_item is
1307: select
1308: fai.value
1309: from ff_archive_items fai,
1310: ff_database_items fdi
1311: where fdi.user_name = w2_per_item
1312: and fdi.user_entity_id = fai.user_entity_id
1313: and fai.context1 = w2_assignment_action_id;
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
1351: where fdi.user_name = w2_state_item
1352: and fdi.user_entity_id = fai.user_entity_id
1353: and fai.context1 = w2_payroll_action_id
1713: CURSOR get_year( cp_action_id number) is
1714:
1715: select fai.value designated_roth_contri
1716: from FF_USER_ENTITIES fue,
1717: FF_ARCHIVE_ITEMS fai
1718: where fai.context1 = cp_action_id
1719: AND fai.user_entity_id = fue.user_entity_id
1720: AND upper(fue.user_entity_name) = 'A_FIRST_YEAR_ROTH_CONTRIB' ;
1721: