DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on FF_DATABASE_ITEMS

Line 1576: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD

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
1579: AND fc1.context_name = 'JURISDICTION_CODE'
1580: AND faic1.context_id = fc1.context_id

Line 1600: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD

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
1603: AND fc1.context_name = 'JURISDICTION_CODE'
1604: AND faic1.context_id = fc1.context_id

Line 1626: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD

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
1629: AND fc1.context_name = 'JURISDICTION_CODE'
1630: AND faic1.context_id = fc1.context_id