DBA Data[Home] [Help]

APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_FEDERAL_ACTION_INFO_V

Line 1230: FROM pay_us_federal_action_info_v fed

1226: sum(medicare_er_taxable),
1227: sum(medicare_er_liability),
1228: sum(eic_advance),
1229: sum(medicare_ee_taxable_over_limit) /* Added for Testing Bug#14793173 */
1230: FROM pay_us_federal_action_info_v fed
1231: WHERE fed.action_number = cp_action_number
1232: /* and cp_action_number not in
1233: (select fed2.action_number
1234: from pay_us_federal_action_info_v fed2

Line 1234: from pay_us_federal_action_info_v fed2

1230: FROM pay_us_federal_action_info_v fed
1231: WHERE fed.action_number = cp_action_number
1232: /* and cp_action_number not in
1233: (select fed2.action_number
1234: from pay_us_federal_action_info_v fed2
1235: where (fed2.fit_gross = 0
1236: or fed2.fit_gross is null)
1237: and (fed2.fit_withheld = 0
1238: or fed2.fit_withheld is null)