DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_FED_LIABILITIES_V

Line 905: from PAY_US_FED_LIABILITIES_V

901:
902:
903: cursor csr_er_tax is
904: select user_reporting_name,'1' sub_class,run_val
905: from PAY_US_FED_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

Line 2462: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_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'''||')
2465: and pet.element_type_id = prr.element_type_id
2466: and prr.assignment_action_id = ';