DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1571: FROM pay_assignment_actions paa, -- YREND PAA

1567: c_state_code VARCHAR2,
1568: c_locality_code VARCHAR2)
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

Line 1595: FROM pay_assignment_actions paa, -- YREND PAA

1591: AND puctif.effective_end_date >= ppa.effective_date
1592: )
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

Line 1621: FROM pay_assignment_actions paa, -- YREND PAA

1617: )
1618: -- Bug # 6117216 SD Reporting Changes START
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