DBA Data[Home] [Help]

APPS.HZ_DNBUI_PVT dependencies on HZ_CREDIT_RATINGS

Line 438: FROM hz_credit_ratings

434: BEGIN
435:
436: SELECT MAX(rated_as_of_date)
437: INTO l_max_rated_as_of_date
438: FROM hz_credit_ratings
439: WHERE party_id = p_party_id
440: AND actual_content_source = p_actual_content_source;
441:
442: SELECT credit_rating_id

Line 444: FROM hz_credit_ratings

440: AND actual_content_source = p_actual_content_source;
441:
442: SELECT credit_rating_id
443: INTO l_credit_rating_id
444: FROM hz_credit_ratings
445: WHERE party_id = p_party_id
446: AND actual_content_source = p_actual_content_source
447: AND NVL(rated_as_of_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'))=
448: NVL(l_max_rated_as_of_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'))