DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on FF_CONTEXTS

Line 1573: ff_contexts fc1, -- FOR CITY CONTEXT

1569: IS
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

Line 1597: ff_contexts fc1, -- FOR CITY CONTEXT

1593: UNION
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

Line 1623: ff_contexts fc1, -- FOR CITY CONTEXT

1619: UNION
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