APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_PERSON_INTEREST

Line 251: Interest N Y HZ_PERSON_INTEREST

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: */
255:

Line 474: SELECT HZ_PERSON_INTEREST_OBJ(

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,
476: NULL, -- COMMON_OBJ_ID
477: PERSON_INTEREST_ID,
478: LEVEL_OF_INTEREST,

Line 495: FROM HZ_PERSON_INTEREST

491: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
492: CREATION_DATE,
493: LAST_UPDATE_DATE,
494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
495: FROM HZ_PERSON_INTEREST
496: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_INTEREST_OBJ_TBL),
497: CAST(MULTISET (
498: SELECT HZ_CERTIFICATION_OBJ(
499: P_ACTION_TYPE,

Line 496: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_INTEREST_OBJ_TBL),

492: CREATION_DATE,
493: LAST_UPDATE_DATE,
494: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
495: FROM HZ_PERSON_INTEREST
496: WHERE PARTY_ID = P_PERSON_ID) AS HZ_PERSON_INTEREST_OBJ_TBL),
497: CAST(MULTISET (
498: SELECT HZ_CERTIFICATION_OBJ(
499: P_ACTION_TYPE,
500: NULL, -- COMMON_OBJ_ID

Line 1330: elsif l_child_entity_name = 'HZ_PERSON_INTEREST' then

1326: l_child_upd_flag := 'Y';
1327: end if;
1328:
1329: end loop;
1330: elsif l_child_entity_name = 'HZ_PERSON_INTEREST' then
1331: for i in 1..PX_PERSON_OBJ.INTEREST_OBJS .COUNT
1332: loop
1333: if PX_PERSON_OBJ.INTEREST_OBJS(i).person_interest_id = l_child_id
1334: then PX_PERSON_OBJ.INTEREST_OBJS(i).action_type := l_action_type;