APPS.PAY_US_TAX_BALANCE_PERF dependencies on DUAL

Line 187: FROM dual

183: END IF;
184: --
185: SELECT count(*)
186: INTO l_valid
187: FROM dual
188: WHERE p_asg_type in ('ASG','PER','GRE');
189: --
190: IF l_valid = 0 THEN
191: hr_utility.trace('Error: Invalid asg_type parameter');

Line 197: FROM dual

193: END IF;
194: --
195: SELECT count(*)
196: INTO l_valid
197: FROM dual
198: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE');
199: --
200: IF l_valid = 0 THEN
201: hr_utility.trace('Error: Invalid time_type parameter');

Line 348: FROM sys.dual

344: -- Check if the tax is federal or not.
345: --
346: SELECT count(*)
347: INTO l_test
348: FROM sys.dual
349: WHERE l_tax_type in ('FIT','FUTA','MEDICARE','SS','EIC');
350: --
351: IF l_test <> 0 THEN -- yes, the tax is federal
352: --

Line 697: * skutteti commented all the individual pre-tax categories and

693: --
694: IF ( l_return_value <> 0 )
695: THEN
696: /***************************************************************
697: * skutteti commented all the individual pre-tax categories and
698: * replaced it by PRE_TAX_REDNS
699: ***************************************************************/
700: -- l_return_value := l_return_value
701: -- - us_tax_balance('401_REDNS',