APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_EMPLOYMENT_HISTORY

Line 902: FROM HZ_EMPLOYMENT_HISTORY

898:
899: CURSOR dupcheck IS
900: SELECT
901: EMPLOYMENT_HISTORY_ID
902: FROM HZ_EMPLOYMENT_HISTORY
903: WHERE party_id = p_to_fk_id
904: AND (status IS NULL OR status = 'A')
905: AND
906: TO_CHAR(BEGIN_DATE, 'DD/MM/YYYY') ||

Line 927: FROM HZ_EMPLOYMENT_HISTORY

923: BRANCH ||
924: MILITARY_RANK ||
925: SERVED ||
926: STATION
927: FROM HZ_EMPLOYMENT_HISTORY
928: WHERE employment_history_id = p_from_id);
929:
930: l_record_id NUMBER;
931: BEGIN