APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 247: Classification N Y HZ_CODE_ASSIGNMENTS

243:
244: Party,Person Profile Y N HZ_PARTIES, HZ_PERSON_PROFILES
245: Person Preference N Y HZ_PARTY_PREFERENCES
246: Relationship N Y HZ_RELATIONSHIPS
247: Classification N Y HZ_CODE_ASSIGNMENTS
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

Line 403: FROM HZ_CODE_ASSIGNMENTS

399: CREATION_DATE,
400: LAST_UPDATE_DATE,
401: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
402: RANK)
403: FROM HZ_CODE_ASSIGNMENTS
404: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
405: AND OWNER_TABLE_ID = P_PERSON_ID) AS HZ_CODE_ASSIGNMENT_OBJ_TBL),
406: CAST(MULTISET (
407: SELECT HZ_PERSON_LANG_OBJ(

Line 1346: elsif l_child_entity_name = 'HZ_CODE_ASSIGNMENTS' then

1342: then PX_PERSON_OBJ.LANGUAGE_OBJS(i).action_type := l_action_type;
1343: l_child_upd_flag := 'Y';
1344: end if;
1345: end loop;
1346: elsif l_child_entity_name = 'HZ_CODE_ASSIGNMENTS' then
1347: for i in 1..PX_PERSON_OBJ.CLASS_OBJS .COUNT
1348: loop
1349: if PX_PERSON_OBJ.CLASS_OBJS(i).code_assignment_id = l_child_id
1350: then PX_PERSON_OBJ.CLASS_OBJS(i).action_type := l_action_type;