DBA Data[Home] [Help]

APPS.PAY_ARCHIVER_REPORT_PKG dependencies on PAY_US_FEDERAL_ACTION_INFO_V

Line 1062: FROM pay_us_federal_action_info_v fed

1058: sum(medicare_ee_withheld),
1059: sum(medicare_er_taxable),
1060: sum(medicare_er_liability),
1061: sum(eic_advance)
1062: FROM pay_us_federal_action_info_v fed
1063: WHERE fed.action_number = cp_action_number
1064: /* and cp_action_number not in
1065: (select fed2.action_number
1066: from pay_us_federal_action_info_v fed2

Line 1066: from pay_us_federal_action_info_v fed2

1062: FROM pay_us_federal_action_info_v fed
1063: WHERE fed.action_number = cp_action_number
1064: /* and cp_action_number not in
1065: (select fed2.action_number
1066: from pay_us_federal_action_info_v fed2
1067: where (fed2.fit_gross = 0
1068: or fed2.fit_gross is null)
1069: and (fed2.fit_withheld = 0
1070: or fed2.fit_withheld is null)