APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATE_LIABILITIES_V

Line 910: from PAY_US_STATE_LIABILITIES_V

906: where assignment_action_id = l_assignment_action_id
907: and ee_or_er_code = 'ER'
908: UNION ALL
909: select user_reporting_name ||' '|| state_name,'2' sub_class,run_val
910: from PAY_US_STATE_LIABILITIES_V
911: where assignment_action_id =l_assignment_action_id
912: and ee_or_er_code = 'ER'
913: UNION ALL
914: select user_reporting_name||' '||(decode(state_name,'INVALID',null,state_name))||

Line 2463: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_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'''||')
2465: and pet.element_type_id = prr.element_type_id
2466: and prr.assignment_action_id = ';
2467: l_futa_from := ' pay_run_results prr ';