DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_CERTIFICATIONS

Line 256: Certification N Y HZ_CERTIFICATIONS

252: Org Preference N Y HZ_PARTY_PREFERENCES
253: Relationship N Y HZ_RELATIONSHIPS
254: Classification N Y HZ_CODE_ASSIGNMENTS
255: Credit Rating N Y HZ_CREDIT_RATINGS
256: Certification N Y HZ_CERTIFICATIONS
257: Financial Profile N Y HZ_FINANCIAL_PROFILE
258:
259: */
260:

Line 616: FROM HZ_CERTIFICATIONS

612: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
613: CREATION_DATE,
614: LAST_UPDATE_DATE,
615: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
616: FROM HZ_CERTIFICATIONS
617: WHERE PARTY_ID = P_ORGANIZATION_ID) AS HZ_CERTIFICATION_OBJ_TBL),
618: CAST(MULTISET (
619: SELECT HZ_FINANCIAL_PROF_OBJ(
620: P_ACTION_TYPE,

Line 1560: elsif l_child_entity_name = 'HZ_CERTIFICATIONS' then

1556: then PX_ORG_OBJ.RELATIONSHIP_OBJS(i).action_type := l_action_type;
1557: l_child_upd_flag := 'Y';
1558: end if;
1559: end loop;
1560: elsif l_child_entity_name = 'HZ_CERTIFICATIONS' then
1561: for i in 1..PX_ORG_OBJ.CERTIFICATION_OBJS .COUNT
1562: loop
1563: if PX_ORG_OBJ.CERTIFICATION_OBJS(i).certification_id = l_child_id
1564: then PX_ORG_OBJ.CERTIFICATION_OBJS(i).action_type := l_action_type;