APPS.PAY_PAYRP940_XMLP_PKG dependencies on PAY_US_STATE_TAX_BAL_GRE_V

Line 496: CP_FROM_TABLE := 'pay_us_state_tax_bal_gre_v';

492: CP_SELECT_COL2 := 'v.d_tax_unit_id ';
493: CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || 'and psr.jurisdiction_code = v.d_state_code ' || ' ';
494: CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || 'and v.d_balance_set_name = ''940_STATE_YTD'' ' || ' ';
495: CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || 'and v.d_tax_type = ''SUI'' ';
496: CP_FROM_TABLE := 'pay_us_state_tax_bal_gre_v';
497: ELSE
498: CP_SELECT_COL1 := '1 ';
499: CP_SELECT_COL2 := 'v.tax_unit_id ';
500: CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || 'and psr.jurisdiction_code = v.state_code ';

Line 538: PAY_US_STATE_TAX_BAL_GRE_V

534: ,1
535: ,2),
536: D_WAGE_OTD_VALUE
537: FROM
538: PAY_US_STATE_TAX_BAL_GRE_V
539: WHERE D_STATE_CODE = '33-000-0000'
540: AND D_BALANCE_SET_NAME = '940_STATE_YTD'
541: AND D_TAX_TYPE = 'FUTA'
542: AND D_TAX_UNIT_ID = TAX_UNIT_ID;