APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_SECURITY_ISSUED

Line 421: FROM HZ_SECURITY_ISSUED

417:
418: CURSOR dupcheck IS
419: SELECT
420: SECURITY_ISSUED_ID
421: FROM HZ_SECURITY_ISSUED
422: WHERE party_id = p_to_fk_id
423: AND (status IS NULL OR status = 'A')
424: AND
425: TO_CHAR(ESTIMATED_TOTAL_AMOUNT) ||

Line 444: FROM HZ_SECURITY_ISSUED

440: STOCK_TICKER_SYMBOL ||
441: SECURITY_CURRENCY_CODE ||
442: TO_CHAR(BEGIN_DATE,'DD/MM/YYYY') ||
443: TO_CHAR(END_DATE,'DD/MM/YYYY')
444: FROM HZ_SECURITY_ISSUED
445: WHERE security_issued_id = p_from_id);
446:
447: l_record_id NUMBER;
448: BEGIN