APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CERTIFICATIONS

Line 292: FROM HZ_CERTIFICATIONS

288:
289: CURSOR dupcheck IS
290: SELECT
291: CERTIFICATION_ID
292: FROM HZ_CERTIFICATIONS
293: WHERE party_id = p_to_fk_id
294: AND (status IS NULL OR status = 'A')
295: AND
296: CERTIFICATION_NAME ||

Line 309: FROM HZ_CERTIFICATIONS

305: TO_CHAR(EXPIRES_ON_DATE, 'DD/MM/YYYY') ||
306: GRADE ||
307: ISSUED_BY_AUTHORITY ||
308: TO_CHAR(ISSUED_ON_DATE, 'DD/MM/YYYY')
309: FROM HZ_CERTIFICATIONS
310: WHERE certification_id = p_from_id);
311:
312: l_record_id NUMBER;
313: BEGIN