APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_EDUCATION

Line 804: FROM HZ_EDUCATION

800: x_object_version_number OUT NOCOPY NUMBER
801: ) IS
802: CURSOR is_edu_id_exist(l_edu_id NUMBER) IS
803: SELECT nvl(object_version_number,1), party_id
804: FROM HZ_EDUCATION
805: WHERE education_id = l_edu_id
806: AND rownum = 1;
807:
808: CURSOR is_education_exist(l_party_id NUMBER, l_course_major VARCHAR2,

Line 812: FROM HZ_EDUCATION

808: CURSOR is_education_exist(l_party_id NUMBER, l_course_major VARCHAR2,
809: l_school_attended_name VARCHAR2,
810: l_degree_received VARCHAR2)IS
811: SELECT nvl(object_version_number,1), education_id
812: FROM HZ_EDUCATION
813: WHERE party_id = l_party_id
814: AND UPPER(ltrim(rtrim(course_major))) = UPPER(ltrim(rtrim(l_course_major)))
815: AND UPPER(ltrim(rtrim(degree_received))) = UPPER(ltrim(rtrim(l_degree_received)))
816: AND UPPER(ltrim(rtrim(school_attended_name))) = UPPER(ltrim(rtrim(l_school_attended_name)))

Line 2855: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY

2851:
2852: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2853: -- get all entities of person, for person, the possible entites are
2854: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,
2855: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY
2856: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,
2857: -- HZ_CONTACT_PREFERENCES
2858: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2859: p_bus_object.user_mandated_flag(i) = 'Y' AND

Line 2871: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN

2867: WHEN p_bus_object.entity_name(i) = 'HZ_CODE_ASSIGNMENTS' THEN
2868: l_class := TRUE;
2869: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN
2870: l_lang := TRUE;
2871: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN
2872: l_edu := TRUE;
2873: WHEN p_bus_object.entity_name(i) = 'HZ_CITIZENSHIP' THEN
2874: l_citiz := TRUE;
2875: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_INTEREST' THEN