APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_REFERENCES

Line 242: FROM HZ_REFERENCES

238:
239: CURSOR dupcheck IS
240: SELECT
241: REFERENCE_ID
242: FROM HZ_REFERENCES
243: WHERE referenced_party_id = p_to_fk_id
244: AND (status IS NULL OR status = 'A')
245: AND
246: TO_CHAR(COMMENTING_PARTY_ID) ||

Line 253: FROM HZ_REFERENCES

249: (SELECT
250: TO_CHAR(COMMENTING_PARTY_ID) ||
251: EXTERNAL_ACCOUNT_NUMBER ||
252: TO_CHAR(REFERENCE_DATE, 'DD/MM/YYYY')
253: FROM HZ_REFERENCES
254: WHERE reference_id = p_from_id);
255:
256: l_record_id NUMBER;
257: BEGIN