APPS.HR_US_W2_REP dependencies on FF_DATABASE_ITEMS

Line 230: from ff_database_items fdi,

226: l_user_entity_id number := 0;
227:
228: BEGIN
229: select fdi.user_entity_id into l_user_entity_id
230: from ff_database_items fdi,
231: ff_user_entities fue
232: where user_name = w2_balance_name
233: and fdi.user_entity_id = fue.user_entity_id
234: and fue.legislation_code = 'US';

Line 277: FF_DATABASE_ITEMS FDI

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
281: ('A_FIT_SUBJ_WHABLE_PER_GRE_YTD',

Line 1226: ff_database_items fdi

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
1230: and fc.context_name = 'TAX_UNIT_ID'

Line 1310: ff_database_items fdi

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;
1314:

Line 1350: ff_database_items fdi

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
1354: and fc2.context_name = 'TAX_UNIT_ID'

Line 1630: from ff_database_items

1626: l_bal_amt number := 0;
1627:
1628: cursor c_userra_db_items (c_userra_code varchar2) is
1629: select user_name
1630: from ff_database_items
1631: where user_name like 'A_W2_USERRA_'||c_userra_code||'%_PER_GRE_YTD';
1632:
1633: l_balance_name ff_database_items.user_name%type;
1634: begin

Line 1633: l_balance_name ff_database_items.user_name%type;

1629: select user_name
1630: from ff_database_items
1631: where user_name like 'A_W2_USERRA_'||c_userra_code||'%_PER_GRE_YTD';
1632:
1633: l_balance_name ff_database_items.user_name%type;
1634: begin
1635: for userra_db_items IN c_userra_db_items(p_userra_code)
1636: loop
1637: l_balance_name :=userra_db_items.user_name;