APPS.PAY_GTNLOD_PKG dependencies on PAY_US_STATE_LIABILITIES_V

Line 1079: from PAY_US_STATE_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
1079: from PAY_US_STATE_LIABILITIES_V
1080: where assignment_action_id =l_assignment_action_id
1081: and ee_or_er_code = 'ER'
1082: UNION ALL
1083: select user_reporting_name||' '||(decode(state_name,'INVALID',null,state_name))||

Line 2658: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_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 = ';
2662: l_futa_from := ' pay_run_results prr ';