APPS.PAY_US_TAX_BALS_PKG dependencies on DUAL

Line 51: tbattoo 11-MAY-1998 40.24(110.1) dual mantained changes in view so

47: lwthomps 27-May-1997 40.22 489769, WC2_EE previously not accessible.
48: Similiar to change for 40.16.
49: tbattoo 16-JAN-1998 40.23(110.0) changed date format to DD-MON-YYYY -
50: bug 612696.
51: tbattoo 11-MAY-1998 40.24(110.1) dual mantained changes in view so
52: GRE PYDATE routes work over a range
53: djoshi 08-APR-1999 Verfied and converted for Canonical
54: Complience of Date
55: skutteti 14-SEP-1999 115.4 Pre-tax enhancements. Added categories 403B

Line 403: from dual

399: --
400: begin
401: select ''
402: into l_dummy
403: from dual
404: where exists (
405: select ''
406: from pay_payroll_actions ppa,
407: pay_assignment_actions paa,

Line 984: FROM dual

980: end if; /* p_tax_balance_category is NONE */
981:
982: SELECT count(0)
983: INTO l_valid
984: FROM dual
985: WHERE p_asg_type in ('ASG','PER','GRE');
986: --
987: IF l_valid = 0 THEN
988: hr_utility.trace('Error: Invalid asg_type parameter');

Line 994: FROM dual

990: END IF;
991: --
992: SELECT count(0)
993: INTO l_valid
994: FROM dual
995: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE');
996: --
997: IF l_valid = 0 THEN
998: hr_utility.trace('Error: Invalid time_type parameter');

Line 1344: FROM sys.dual

1340: -- Check if the tax is federal or not.
1341: --
1342: SELECT count(0)
1343: INTO l_test
1344: FROM sys.dual
1345: WHERE l_tax_type in ('FIT','FUTA','MEDICARE','SS','EIC');
1346:
1347:
1348: IF ((p_jd_context IS NOT NULL) and