DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PAY_US_GTN_DEDUCT_V

Line 168: from PAY_US_GTN_DEDUCT_V

164: select classification_name,
165: decode(classification_name,'Pre-Tax Deductions','1','Involuntary Deductions','2','Voluntary Deductions','3','9')subclass,
166: element_name,
167: RUN_VALUE cash_value
168: from PAY_US_GTN_DEDUCT_V
169: where assignment_action_id =l_assignment_action_id
170: and classification_name in ('Pre-Tax Deductions',
171: 'Involuntary Deductions',
172: 'Voluntary Deductions');

Line 2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';

2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_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';