APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CREDIT_RATINGS

Line 1518: FROM HZ_CREDIT_RATINGS

1514: x_object_version_number OUT NOCOPY NUMBER
1515: ) IS
1516: CURSOR is_credit_rating_id_exist(l_credit_rating_id NUMBER)IS
1517: SELECT nvl(object_version_number,1), party_id
1518: FROM HZ_CREDIT_RATINGS
1519: WHERE credit_rating_id = l_credit_rating_id
1520: AND rownum = 1;
1521:
1522: CURSOR is_credit_rating_exist(l_party_id NUMBER, l_rating_organization VARCHAR2,

Line 1525: FROM HZ_CREDIT_RATINGS

1521:
1522: CURSOR is_credit_rating_exist(l_party_id NUMBER, l_rating_organization VARCHAR2,
1523: l_rated_as_of_date DATE)IS
1524: SELECT nvl(object_version_number,1), credit_rating_id
1525: FROM HZ_CREDIT_RATINGS
1526: WHERE party_id = l_party_id
1527: AND nvl(rating_organization,'A') = nvl(l_rating_organization,'A')
1528: AND trunc(nvl(rated_as_of_date,sysdate)) = trunc(nvl(l_rated_as_of_date,sysdate))
1529: AND status in ('A','I')

Line 3290: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,

3286: l_ext := FALSE;
3287:
3288: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3289: -- get all entities of org, for org, the possible entites are
3290: -- HZ_PARTY_PREFERENCES, HZ_CREDIT_RATINGS, HZ_RELATIONSHIPS,
3291: -- HZ_CODE_ASSIGNMENTS, HZ_FINANCIAL_REPORTS, HZ_FINANCIAL_NUMBERS,
3292: -- HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE, HZ_CONTACT_PREFERENCES
3293: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3294: p_bus_object.user_mandated_flag(i) = 'Y' AND

Line 3300: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN

3296: p_bus_object.child_bo_code(i) IS NULL) THEN
3297: CASE
3298: WHEN p_bus_object.entity_name(i) = 'HZ_PARTY_PREFERENCES' THEN
3299: l_pref := TRUE;
3300: WHEN p_bus_object.entity_name(i) = 'HZ_CREDIT_RATINGS' THEN
3301: l_credit := TRUE;
3302: WHEN p_bus_object.entity_name(i) = 'HZ_RELATIONSHIPS' THEN
3303: l_rel := TRUE;
3304: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN