APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATE_TAXES_V

Line 762: from PAY_US_STATE_TAXES_V

758: and ee_or_er_code = 'EE'
759: and tax_type_code <> 'EIC'
760: UNION ALL
761: select user_reporting_name ||' '|| state_name,'2' sub_class,run_val,TAX_TYPE_CODE,jurisdiction_code
762: from PAY_US_STATE_TAXES_V
763: where assignment_action_id =l_assignment_action_id
764: and ee_or_er_code = 'EE'
765: and tax_type_code <> 'STEIC'
766: UNION ALL

Line 1282: from PAY_US_STATE_TAXES_V

1278: and ee_or_er_code = 'EE'
1279: and tax_type_code = 'EIC'
1280: UNION ALL
1281: select user_reporting_name ,run_val
1282: from PAY_US_STATE_TAXES_V
1283: where assignment_action_id =l_assignment_action_id
1284: and ee_or_er_code = 'EE'
1285: and tax_type_code = 'STEIC';
1286:

Line 2655: l_state_view_name := 'PAY_US_STATE_TAXES_V';

2651:
2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2654: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2655: l_state_view_name := 'PAY_US_STATE_TAXES_V';
2656: l_local_view_name := 'PAY_US_LOCAL_TAXES_V';
2657: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_V';
2658: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_V';
2659: l_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')