DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_EMPLOYMENT_HISTORY

Line 107: FROM HZ_EMPLOYMENT_HISTORY

103: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
104: FROM HZ_WORK_CLASS
105: WHERE WORK_CLASS_ID = P_PERSON_ID
106: AND WORK_CLASS_NAME = 'HZ_PARTIES') AS HZ_WORK_CLASS_OBJ_TBL))
107: FROM HZ_EMPLOYMENT_HISTORY
108: WHERE PARTY_ID = P_PERSON_ID;
109:
110: l_debug_prefix VARCHAR2(30) := '';
111:

Line 236: Employment History N Y Business Structure. Included entities:HZ_EMPLOYMENT_HISTORY, HZ_WORK_CLASS

232: Phone N Y get_phone_bo
233: Email N Y get_email_bo
234: Web N Y get_web_bo
235: SMS N Y get_sms_bo
236: Employment History N Y Business Structure. Included entities:HZ_EMPLOYMENT_HISTORY, HZ_WORK_CLASS
237:
238:
239: To retrieve the appropriate embedded entities within the Person business object,
240: the Get procedure returns all records for the particular person from these TCA entity tables:

Line 1575: if l_child_entity_name = 'HZ_EMPLOYMENT_HISTORY'

1571: then
1572: for i in 1..PX_PERSON_OBJ.EMPLOY_HIST_OBJS.COUNT
1573: loop
1574: -- check root level
1575: if l_child_entity_name = 'HZ_EMPLOYMENT_HISTORY'
1576: then
1577: if px_person_obj.EMPLOY_HIST_OBJS(i).EMPLOYMENT_HISTORY_ID = l_child_id
1578: then
1579: px_person_obj.EMPLOY_HIST_OBJS(i).action_type := l_action_type;