DBA Data[Home] [Help]

APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1497: FROM pay_assignment_actions paa, -- YREND PAA

1493: c_state_code VARCHAR2,
1494: c_locality_code VARCHAR2)
1495: IS
1496: SELECT faic1.context Jurisdiction_code
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

Line 1521: FROM pay_assignment_actions paa, -- YREND PAA

1517: AND puctif.effective_end_date >= ppa.effective_date
1518: )
1519: UNION
1520: SELECT faic1.context Jurisdiction_code
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

Line 1547: FROM pay_assignment_actions paa, -- YREND PAA

1543: )
1544: -- Bug # 6117216 SD Reporting Changes START
1545: UNION
1546: SELECT faic1.context Jurisdiction_code
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