APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_CITIZENSHIP

Line 250: Citizenship N Y HZ_CITIZENSHIP

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
252: Certification N Y HZ_CERTIFICATIONS
253: Financial Profile N Y HZ_FINANCIAL_PROFILE
254: */

Line 451: SELECT HZ_CITIZENSHIP_OBJ(

447: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
448: FROM HZ_EDUCATION
449: WHERE PARTY_ID = P_PERSON_ID) AS HZ_EDUCATION_OBJ_TBL),
450: CAST(MULTISET (
451: SELECT HZ_CITIZENSHIP_OBJ(
452: P_ACTION_TYPE,
453: NULL, -- COMMON_OBJ_ID
454: CITIZENSHIP_ID,
455: PARTY_ID,

Line 470: FROM HZ_CITIZENSHIP

466: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
467: CREATION_DATE,
468: LAST_UPDATE_DATE,
469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
470: FROM HZ_CITIZENSHIP
471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),
472: HZ_EMPLOY_HIST_BO_TBL(),
473: CAST(MULTISET (
474: SELECT HZ_PERSON_INTEREST_OBJ(

Line 471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),

467: CREATION_DATE,
468: LAST_UPDATE_DATE,
469: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
470: FROM HZ_CITIZENSHIP
471: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CITIZENSHIP_OBJ_TBL),
472: HZ_EMPLOY_HIST_BO_TBL(),
473: CAST(MULTISET (
474: SELECT HZ_PERSON_INTEREST_OBJ(
475: P_ACTION_TYPE,

Line 1306: elsif l_child_entity_name = 'HZ_CITIZENSHIP' then

1302: then PX_PERSON_OBJ.PARTY_USAGE_OBJS(i).action_type := l_action_type;
1303: l_child_upd_flag := 'Y';
1304: end if;
1305: end loop;
1306: elsif l_child_entity_name = 'HZ_CITIZENSHIP' then
1307: for i in 1..PX_PERSON_OBJ.CITIZENSHIP_OBJS .COUNT
1308: loop
1309: if PX_PERSON_OBJ.CITIZENSHIP_OBJS(i).citizenship_id = l_child_id
1310: then PX_PERSON_OBJ.CITIZENSHIP_OBJS(i).action_type := l_action_type;