APPS.AP_WEB_DB_HR_INT_PKG dependencies on DUAL

Line 567: FROM DUAL

563: -- This query returns rows if there exist an active employee or cwk
564: -- record for the given person ID.
565: SELECT 1
566: INTO v_numRows
567: FROM DUAL
568: WHERE exists
569: (SELECT 1
570: FROM
571: per_people_f p,

Line 616: FROM DUAL

612: -- This query returns rows if there exist an active employee or cwk
613: -- record for the given person ID.
614: SELECT 1
615: INTO v_numRows
616: FROM DUAL
617: WHERE EXISTS
618: (SELECT 1
619: FROM
620: per_cont_workers_current_x p

Line 687: FROM DUAL

683: -- employee or cwk record for the given person ID.
684:
685: SELECT 1
686: INTO v_numRows
687: FROM DUAL
688: WHERE exists
689: (SELECT 1
690: FROM
691: per_people_f p,

Line 854: FROM DUAL

850: v_numRows NUMBER := 0;
851: BEGIN
852:
853: SELECT 1 into v_numRows
854: FROM DUAL
855: WHERE EXISTS
856: (SELECT 1 FROM fnd_user fnd, wf_users wf
857: WHERE fnd.user_name = wf.name and employee_id = p_emp_id
858: AND ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')