APPS.PAY_US_TAX_BALANCE_PERF dependencies on DUAL

Line 256: FROM dual

252: END IF;
253: --
254: SELECT count(*)
255: INTO l_valid
256: FROM dual
257: WHERE p_asg_type in ('ASG','PER','GRE');
258: --
259: IF l_valid = 0 THEN
260: hr_utility.trace('Error: Invalid asg_type parameter');

Line 266: FROM dual

262: END IF;
263: --
264: SELECT count(*)
265: INTO l_valid
266: FROM dual
267: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE');
268: --
269: IF l_valid = 0 THEN
270: hr_utility.trace('Error: Invalid time_type parameter');

Line 437: FROM sys.dual

433: -- Check if the tax is federal or not.
434: --
435: SELECT count(*)
436: INTO l_test
437: FROM sys.dual
438: WHERE l_tax_type in ('FIT','FUTA','MEDICARE','SS','EIC');
439: --
440: IF l_test <> 0 THEN -- yes, the tax is federal
441: --

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

907: --
908: IF ( l_return_value <> 0 )
909: THEN
910: /***************************************************************
911: * skutteti commented all the individual pre-tax categories and
912: * replaced it by PRE_TAX_REDNS
913: ***************************************************************/
914: -- l_return_value := l_return_value
915: -- - us_tax_balance('401_REDNS',