APPS.AP_WEB_DB_HR_INT_PKG dependencies on DUAL

Line 566: FROM DUAL

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

Line 615: FROM DUAL

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

Line 686: FROM DUAL

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

Line 853: FROM DUAL

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