APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_WORK_CLASS

Line 857: FROM HZ_WORK_CLASS

853: RETURN VARCHAR2 IS
854: CURSOR dupcheck IS
855: SELECT
856: WORK_CLASS_ID
857: FROM HZ_WORK_CLASS
858: WHERE employment_history_id = p_to_fk_id
859: AND (status IS NULL OR status = 'A')
860: AND
861: WORK_CLASS_NAME =

Line 864: FROM HZ_WORK_CLASS

860: AND
861: WORK_CLASS_NAME =
862: (SELECT
863: WORK_CLASS_NAME
864: FROM HZ_WORK_CLASS
865: WHERE work_class_id = p_from_id);
866: l_record_id NUMBER;
867: BEGIN
868: