DBA Data[Home] [Help]

APPS.PAY_US_941_REPORT dependencies on PAY_US_FEDERAL_TAX_BAL_GRE_V

Line 391: -- The cursor uses the view pay_us_federal_tax_bal_gre_v which

387:
388: --******** Generate Federal Tax Balances (declarations start)
389: -- Get details for Total Wages
390: -- Cursor to fetch the balance values making use of the BRA
391: -- The cursor uses the view pay_us_federal_tax_bal_gre_v which
392: -- gets the balance information from the table pay_balance_sets.
393: CURSOR c_bal_values (cp_tax_unit_id IN NUMBER) IS
394: SELECT d_tax_otd_value,
395: d_wage_otd_value,

Line 397: FROM pay_us_federal_tax_bal_gre_v

393: CURSOR c_bal_values (cp_tax_unit_id IN NUMBER) IS
394: SELECT d_tax_otd_value,
395: d_wage_otd_value,
396: d_tax_type
397: FROM pay_us_federal_tax_bal_gre_v
398: WHERE d_balance_set_name = '941_QTD'
399: AND d_tax_unit_id = cp_tax_unit_id;
400:
401: