APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATE_TAXES_V

Line 646: from PAY_US_STATE_TAXES_V

642: and ee_or_er_code = 'EE'
643: and tax_type_code <> 'EIC'
644: UNION ALL
645: select user_reporting_name ||' '|| state_name,'2' sub_class,run_val,TAX_TYPE_CODE,jurisdiction_code
646: from PAY_US_STATE_TAXES_V
647: where assignment_action_id =l_assignment_action_id
648: and ee_or_er_code = 'EE'
649: and tax_type_code <> 'STEIC'
650: UNION ALL

Line 1113: from PAY_US_STATE_TAXES_V

1109: and ee_or_er_code = 'EE'
1110: and tax_type_code = 'EIC'
1111: UNION ALL
1112: select user_reporting_name ,run_val
1113: from PAY_US_STATE_TAXES_V
1114: where assignment_action_id =l_assignment_action_id
1115: and ee_or_er_code = 'EE'
1116: and tax_type_code = 'STEIC';
1117:

Line 2460: l_state_view_name := 'PAY_US_STATE_TAXES_V';

2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2458: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2459: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2460: l_state_view_name := 'PAY_US_STATE_TAXES_V';
2461: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';
2462: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_V';
2463: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_V';
2464: l_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')