DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on FF_ARCHIVE_ITEMS

Line 1574: ff_archive_items fai1, -- CITY

1570: SELECT faic1.context Jurisdiction_code
1571: FROM pay_assignment_actions paa, -- YREND PAA
1572: pay_payroll_actions ppa, -- YREND PPA
1573: ff_contexts fc1, -- FOR CITY CONTEXT
1574: ff_archive_items fai1, -- CITY
1575: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1576: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1577: WHERE paa.assignment_action_id = c_asgn_act_id
1578: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1598: ff_archive_items fai1, -- CITY

1594: SELECT faic1.context Jurisdiction_code
1595: FROM pay_assignment_actions paa, -- YREND PAA
1596: pay_payroll_actions ppa, -- YREND PPA
1597: ff_contexts fc1, -- FOR CITY CONTEXT
1598: ff_archive_items fai1, -- CITY
1599: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1600: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1601: WHERE paa.assignment_action_id = c_asgn_act_id
1602: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1624: ff_archive_items fai1, -- CITY

1620: SELECT faic1.context Jurisdiction_code
1621: FROM pay_assignment_actions paa, -- YREND PAA
1622: pay_payroll_actions ppa, -- YREND PPA
1623: ff_contexts fc1, -- FOR CITY CONTEXT
1624: ff_archive_items fai1, -- CITY
1625: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1626: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1627: WHERE paa.assignment_action_id = c_asgn_act_id
1628: AND ppa.payroll_action_id = paa.payroll_action_id