DBA Data[Home] [Help]

APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_FED_TAXES_RBR_V

Line 1301: FROM pay_us_fed_taxes_rbr_v

1297: SELECT user_reporting_name,
1298: run_val,
1299: ytd_val,
1300: tax_type_code
1301: FROM pay_us_fed_taxes_rbr_v
1302: WHERE ee_or_er_code = 'EE'
1303: AND balance_category_code in ('WITHHELD','ADVANCED')
1304: AND assignment_action_id = l_assignment_action_id
1305: order by user_reporting_name;

Line 1313: from pay_us_fed_taxes_rbr_v pt

1309: IS
1310: select pt.user_reporting_name
1311: , sum(pt.run_val)
1312: ,pt.tax_type_code
1313: from pay_us_fed_taxes_rbr_v pt
1314: where pt.ee_or_er_code = 'EE'
1315: and pt.balance_category_code in ('WITHHELD','ADVANCED')
1316: and pt.assignment_action_id = cp_run_action_id
1317: group by pt.user_reporting_name,tax_type_code

Line 1326: from pay_us_fed_taxes_rbr_v pt

1322: IS
1323: select sum(pt.ytd_val) run_val,
1324: pt.user_reporting_name,
1325: tax_type_code
1326: from pay_us_fed_taxes_rbr_v pt
1327: where pt.ee_or_er_code = 'EE'
1328: and pt.balance_category_code in ('WITHHELD','ADVANCED')
1329: and pt.assignment_action_id = cp_master_action_id
1330: group by pt.user_reporting_name,tax_type_code