DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 1501: ff_archive_item_contexts faic1, -- CITY_CONTEXT

1497: FROM pay_assignment_actions paa, -- YREND PAA
1498: pay_payroll_actions ppa, -- YREND PPA
1499: ff_contexts fc1, -- FOR CITY CONTEXT
1500: ff_archive_items fai1, -- CITY
1501: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1502: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1503: WHERE paa.assignment_action_id = c_asgn_act_id
1504: AND ppa.payroll_action_id = paa.payroll_action_id
1505: AND fc1.context_name = 'JURISDICTION_CODE'

Line 1525: ff_archive_item_contexts faic1, -- CITY_CONTEXT

1521: FROM pay_assignment_actions paa, -- YREND PAA
1522: pay_payroll_actions ppa, -- YREND PPA
1523: ff_contexts fc1, -- FOR CITY CONTEXT
1524: ff_archive_items fai1, -- CITY
1525: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1526: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1527: WHERE paa.assignment_action_id = c_asgn_act_id
1528: AND ppa.payroll_action_id = paa.payroll_action_id
1529: AND fc1.context_name = 'JURISDICTION_CODE'

Line 1551: ff_archive_item_contexts faic1, -- CITY_CONTEXT

1547: FROM pay_assignment_actions paa, -- YREND PAA
1548: pay_payroll_actions ppa, -- YREND PPA
1549: ff_contexts fc1, -- FOR CITY CONTEXT
1550: ff_archive_items fai1, -- CITY
1551: ff_archive_item_contexts faic1, -- CITY_CONTEXT
1552: ff_database_items fdi1 --DATABASE_ITEMS FOR CITY_WITHHELD
1553: WHERE paa.assignment_action_id = c_asgn_act_id
1554: AND ppa.payroll_action_id = paa.payroll_action_id
1555: AND fc1.context_name = 'JURISDICTION_CODE'