APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CREDIT_RATINGS

Line 348: FROM HZ_CREDIT_RATINGS

344:
345: CURSOR dupcheck (source_type VARCHAR2) IS
346: SELECT
347: CREDIT_RATING_ID
348: FROM HZ_CREDIT_RATINGS
349: WHERE party_id = p_to_fk_id
350: AND
351: TO_CHAR(RATED_AS_OF_DATE, 'DD/MM/YYYY') ||
352: RATING_ORGANIZATION ||

Line 357: DECODE (source_type,'P',actual_content_source,'S') FROM HZ_CREDIT_RATINGS

353: DECODE (source_type,'P',actual_content_source,'S') =
354: (SELECT
355: TO_CHAR(RATED_AS_OF_DATE, 'DD/MM/YYYY') ||
356: RATING_ORGANIZATION ||
357: DECODE (source_type,'P',actual_content_source,'S') FROM HZ_CREDIT_RATINGS
358: WHERE credit_rating_id = p_from_id);
359:
360: CURSOR c_cont_source IS
361: SELECT ACTUAL_CONTENT_SOURCE

Line 362: FROM HZ_CREDIT_RATINGS

358: WHERE credit_rating_id = p_from_id);
359:
360: CURSOR c_cont_source IS
361: SELECT ACTUAL_CONTENT_SOURCE
362: FROM HZ_CREDIT_RATINGS
363: WHERE credit_rating_id = p_from_id;
364:
365: l_cont_source VARCHAR2(255);
366: l_record_id NUMBER;