APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_INDUSTRIAL_REFERENCE

Line 644: FROM HZ_INDUSTRIAL_REFERENCE

640:
641: CURSOR dupcheck IS
642: SELECT
643: INDUSTRY_REFERENCE_ID
644: FROM HZ_INDUSTRIAL_REFERENCE
645: WHERE party_id = p_to_fk_id
646: AND (status IS NULL OR status = 'A')
647: AND
648: INDUSTRY_REFERENCE ||

Line 657: FROM HZ_INDUSTRIAL_REFERENCE

653: INDUSTRY_REFERENCE ||
654: ISSUED_BY_AUTHORITY ||
655: NAME_OF_REFERENCE ||
656: TO_CHAR(RECOGNIZED_AS_OF_DATE,'DD/MM/YYYY')
657: FROM HZ_INDUSTRIAL_REFERENCE
658: WHERE industry_reference_id = p_from_id);
659:
660: l_record_id NUMBER;
661: BEGIN