APPS.HZ_PARTY_V2PUB dependencies on HZ_CREDIT_RATINGS

Line 6338: -- call to insert credit related columns to hz_credit_ratings.

6334: x_return_status => x_return_status,
6335: p_person_rec => G_MISS_PERSON_REC,
6336: p_group_rec => G_MISS_GROUP_REC );
6337:
6338: -- call to insert credit related columns to hz_credit_ratings.
6339:
6340: IF l_organization_rec.actual_content_source IN
6341: (G_MISS_CONTENT_SOURCE_TYPE, G_SST_SOURCE_TYPE)
6342: THEN

Line 6841: FROM hz_credit_ratings

6837: THEN
6838: -- Bug 3868940
6839: BEGIN
6840: SELECT 'U' INTO l_create_update_flag
6841: FROM hz_credit_ratings
6842: WHERE party_id = p_organization_rec.party_rec.party_id
6843: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
6844: AND ROWNUM = 1;
6845: l_organization_rec.created_by_module:=NULL;

Line 8427: FROM hz_credit_ratings

8423: -- get the latest record for one party_id
8424:
8425: SELECT MAX(rated_as_of_date)
8426: INTO l_rated_as_of_date
8427: FROM hz_credit_ratings
8428: WHERE party_id = p_organization_rec.party_rec.party_id
8429: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE;
8430:
8431: /*IF g_debug THEN

Line 8450: FROM hz_credit_ratings

8446:
8447: BEGIN
8448: SELECT credit_rating_id, last_update_date,object_version_number
8449: INTO l_credit_rating_id, l_last_update_date,l_object_version_number
8450: FROM hz_credit_ratings
8451: WHERE party_id = p_organization_rec.party_rec.party_id
8452: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8453: AND(rated_as_of_date = l_rated_as_of_date OR
8454: (rated_as_of_date is null AND

Line 8460: FROM hz_credit_ratings

8456: EXCEPTION
8457: WHEN TOO_MANY_ROWS THEN
8458: SELECT credit_rating_id, last_update_date,object_version_number
8459: INTO l_credit_rating_id, l_last_update_date,l_object_version_number
8460: FROM hz_credit_ratings
8461: WHERE party_id = p_organization_rec.party_rec.party_id
8462: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8463: AND (rated_as_of_date = l_rated_as_of_date OR
8464: (rated_as_of_date is null AND

Line 8468: FROM hz_credit_ratings

8464: (rated_as_of_date is null AND
8465: l_rated_as_of_date is null))
8466: AND last_update_date = (
8467: SELECT MAX(last_update_date)
8468: FROM hz_credit_ratings
8469: WHERE party_id = p_organization_rec.party_rec.party_id
8470: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8471: AND (rated_as_of_date = l_rated_as_of_date OR
8472: (rated_as_of_date is null AND