APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_CERTIFICATIONS

Line 252: Certification N Y HZ_CERTIFICATIONS

248: Language N Y HZ_PERSON_LANGUAGE
249: Education N Y HZ_EDUCATION
250: Citizenship N Y HZ_CITIZENSHIP
251: Interest N Y HZ_PERSON_INTEREST
252: Certification N Y HZ_CERTIFICATIONS
253: Financial Profile N Y HZ_FINANCIAL_PROFILE
254: */
255:
256:

Line 517: FROM HZ_CERTIFICATIONS

513: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
514: CREATION_DATE,
515: LAST_UPDATE_DATE,
516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
517: FROM HZ_CERTIFICATIONS
518: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CERTIFICATION_OBJ_TBL),
519: CAST(MULTISET (
520: SELECT HZ_FINANCIAL_PROF_OBJ(
521: P_ACTION_TYPE,

Line 1321: elsif l_child_entity_name = 'HZ_CERTIFICATIONS' then

1317: then PX_PERSON_OBJ.RELATIONSHIP_OBJS(i).action_type := l_action_type;
1318: l_child_upd_flag := 'Y';
1319: end if;
1320: end loop;
1321: elsif l_child_entity_name = 'HZ_CERTIFICATIONS' then
1322: for i in 1..PX_PERSON_OBJ.CERTIFICATION_OBJS .COUNT
1323: loop
1324: if PX_PERSON_OBJ.CERTIFICATION_OBJS(i).certification_id = l_child_id
1325: then PX_PERSON_OBJ.CERTIFICATION_OBJS(i).action_type := l_action_type;