APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CITIZENSHIP

Line 743: FROM HZ_CITIZENSHIP

739:
740: CURSOR dupcheck IS
741: SELECT
742: CITIZENSHIP_ID
743: FROM HZ_CITIZENSHIP
744: WHERE party_id = p_to_fk_id
745: AND (status IS NULL OR status = 'A')
746: AND
747: BIRTH_OR_SELECTED ||

Line 762: FROM HZ_CITIZENSHIP

758: TO_CHAR(DATE_RECOGNIZED, 'DD/MM/YYYY') ||
759: DOCUMENT_REFERENCE ||
760: TO_CHAR(END_DATE, 'DD/MM/YYYY') ||
761: DOCUMENT_TYPE
762: FROM HZ_CITIZENSHIP
763: WHERE citizenship_id = p_from_id);
764:
765: l_record_id NUMBER;
766: BEGIN