DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on DUAL

Line 356: from sys.dual;

352:
353: -- copied from peper01t.pkb ( bug 1368672 )
354: --
355: cursor c1 is select per_people_s.nextval
356: from sys.dual;
357: --
358: --
359: -- Retrieve the person type id if the applicant is terminated
360: function get_ex_apl_person_type_id ( p_business_group_id in number )

Line 1795: FROM SYS.DUAL

1791: l_dummy_number number ; -- Used to discard output from cursor
1792: --
1793: cursor c1 is
1794: SELECT 1
1795: FROM SYS.DUAL
1796: WHERE EXISTS
1797: (SELECT NULL
1798: FROM PER_VALID_GRADES
1799: WHERE business_group_id + 0 = p_business_group_id

Line 1807: FROM SYS.DUAL

1803: AND JOB_ID = p_job_id ) ;
1804: --
1805: cursor c2 is
1806: SELECT 1
1807: FROM SYS.DUAL
1808: WHERE EXISTS
1809: (SELECT NULL
1810: FROM PER_VALID_GRADES
1811: WHERE business_group_id + 0 = p_business_group_id