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 997: ff_archive_items fai1, -- city

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

Line 1080: ff_archive_items fai,

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

Line 1297: FROM ff_archive_items fai,

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

Line 1347: FROM ff_archive_items fai,

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

Line 1451: ff_archive_items target,

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