APPS.HZ_PARTY_V2PUB dependencies on HZ_CREDIT_RATINGS

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

6263: x_return_status => x_return_status,
6264: p_person_rec => G_MISS_PERSON_REC,
6265: p_group_rec => G_MISS_GROUP_REC );
6266:
6267: -- call to insert credit related columns to hz_credit_ratings.
6268:
6269: IF l_organization_rec.actual_content_source IN
6270: (G_MISS_CONTENT_SOURCE_TYPE, G_SST_SOURCE_TYPE)
6271: THEN

Line 6760: FROM hz_credit_ratings

6756: THEN
6757: -- Bug 3868940
6758: BEGIN
6759: SELECT 'U' INTO l_create_update_flag
6760: FROM hz_credit_ratings
6761: WHERE party_id = p_organization_rec.party_rec.party_id
6762: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
6763: AND ROWNUM = 1;
6764: l_organization_rec.created_by_module:=NULL;

Line 8315: FROM hz_credit_ratings

8311: -- get the latest record for one party_id
8312:
8313: SELECT MAX(rated_as_of_date)
8314: INTO l_rated_as_of_date
8315: FROM hz_credit_ratings
8316: WHERE party_id = p_organization_rec.party_rec.party_id
8317: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE;
8318:
8319: /*IF g_debug THEN

Line 8338: FROM hz_credit_ratings

8334:
8335: BEGIN
8336: SELECT credit_rating_id, last_update_date,object_version_number
8337: INTO l_credit_rating_id, l_last_update_date,l_object_version_number
8338: FROM hz_credit_ratings
8339: WHERE party_id = p_organization_rec.party_rec.party_id
8340: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8341: AND(rated_as_of_date = l_rated_as_of_date OR
8342: (rated_as_of_date is null AND

Line 8348: FROM hz_credit_ratings

8344: EXCEPTION
8345: WHEN TOO_MANY_ROWS THEN
8346: SELECT credit_rating_id, last_update_date,object_version_number
8347: INTO l_credit_rating_id, l_last_update_date,l_object_version_number
8348: FROM hz_credit_ratings
8349: WHERE party_id = p_organization_rec.party_rec.party_id
8350: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8351: AND (rated_as_of_date = l_rated_as_of_date OR
8352: (rated_as_of_date is null AND

Line 8356: FROM hz_credit_ratings

8352: (rated_as_of_date is null AND
8353: l_rated_as_of_date is null))
8354: AND last_update_date = (
8355: SELECT MAX(last_update_date)
8356: FROM hz_credit_ratings
8357: WHERE party_id = p_organization_rec.party_rec.party_id
8358: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE
8359: AND (rated_as_of_date = l_rated_as_of_date OR
8360: (rated_as_of_date is null AND