DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_FED_LIABILITIES_V

Line 1074: from PAY_US_FED_LIABILITIES_V

1070:
1071:
1072: cursor csr_er_tax is
1073: select user_reporting_name,'1' sub_class,run_val
1074: from PAY_US_FED_LIABILITIES_V
1075: where assignment_action_id = l_assignment_action_id
1076: and ee_or_er_code = 'ER'
1077: UNION ALL
1078: select user_reporting_name ||' '|| state_name,'2' sub_class,run_val

Line 2657: l_fed_liab_view_name := 'PAY_US_FED_LIABILITIES_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'''||')
2660: and pet.element_type_id = prr.element_type_id
2661: and prr.assignment_action_id = ';