APPS.PAY_US_MMREF_LOCAL dependencies on FF_ARCHIVE_ITEMS

Line 363: ff_archive_items target,

359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi
365: WHERE target.context1 = to_char(cp_payroll_action_id)
366: /* context of payroll_action_id */
367: AND fdi.user_name = 'A_FIPS_CODE_JD'

Line 901: ff_archive_items fai,

897: p_sqlstr := '
898: SELECT DISTINCT
899: to_number(paa.serial_number)
900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,
905: per_all_assignments_f paf,

Line 996: ff_archive_items fai1, -- city

992: pay_payroll_actions ppa, /* YREND PPA */
993: per_all_assignments_f paf,
994: pay_payroll_actions ppa1,
995: ff_contexts fc1 , --for city context
996: ff_archive_items fai1, -- city
997: ff_archive_item_contexts faic1, -- city_context
998: ff_database_items fdi1 --database_items for City_withheld
999: --,pay_us_city_tax_info_f puctif
1000: WHERE

Line 1079: ff_archive_items fai,

1075: cursor csr_get_fed_wages(p_assignment_action_id number,
1076: p_tax_unit_id number) is
1077: select to_number(fai.value)
1078: from ff_archive_item_contexts faic,
1079: ff_archive_items fai,
1080: ff_contexts fc,
1081: ff_database_items fdi
1082: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1083: and fc.context_name = 'TAX_UNIT_ID'

Line 1296: FROM ff_archive_items fai,

1292: FOR c_id IN c_get_user_entity_id LOOP
1293:
1294: SELECT value
1295: INTO l_ein_val
1296: FROM ff_archive_items fai,
1297: ff_contexts fc,
1298: ff_archive_item_contexts faic
1299: WHERE fai.context1 = to_char(p_pactid)
1300: AND user_entity_id = c_id.user_entity_id

Line 1346: FROM ff_archive_items fai,

1342:
1343: CURSOR c_get_state_id
1344: IS
1345: SELECT value
1346: FROM ff_archive_items fai,
1347: ff_archive_item_contexts faic,
1348: ff_archive_item_contexts faic1
1349: WHERE context1 = to_char(p_pactid)
1350: AND user_entity_id = l_sit_state_id

Line 1450: ff_archive_items target,

1446: ff_archive_item_contexts con3,
1447: ff_archive_item_contexts con2,
1448: ff_contexts fc3,
1449: ff_contexts fc2,
1450: ff_archive_items target,
1451: ff_database_items fdi
1452: WHERE target.context1 = to_char(cp_payroll_action_id)
1453: /* context of payroll_action_id */
1454: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'