DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_CREDIT_RATINGS

Line 1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

1017:
1018: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_RELATIONSHIPS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1019: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1020: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1021: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CREDIT_RATINGS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1022: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_REPORTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1023: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_FINANCIAL_NUMBERS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1024: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CODE_ASSIGNMENTS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');
1025: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_ORGANIZATION_INDICATORS', 'content_source_type_sec', l_apps_schema, 'hz_common_pub.content_source_type_security');

Line 4686: FROM hz_credit_ratings

4682: BEGIN
4683:
4684: SELECT MAX(rated_as_of_date)
4685: INTO l_max_rated_as_of_date
4686: FROM hz_credit_ratings
4687: WHERE party_id = p_credit_ratings_rec.party_id
4688: AND actual_content_source = p_credit_ratings_rec.actual_content_source;
4689:
4690: SELECT rated_as_of_date, credit_rating_id, last_update_date, object_version_number

Line 4692: FROM hz_credit_ratings

4688: AND actual_content_source = p_credit_ratings_rec.actual_content_source;
4689:
4690: SELECT rated_as_of_date, credit_rating_id, last_update_date, object_version_number
4691: INTO l_rated_as_of_date, l_credit_rating_id, l_last_update_date1, l_ovn
4692: FROM hz_credit_ratings
4693: WHERE party_id = p_credit_ratings_rec.party_id
4694: AND actual_content_source = p_credit_ratings_rec.actual_content_source
4695: AND NVL(rated_as_of_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'))=
4696: NVL(l_max_rated_as_of_date, TO_DATE('31-12-4712', 'DD-MM-YYYY'))