APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_EMPLOYMENT_HISTORY

Line 928: FROM HZ_EMPLOYMENT_HISTORY

924: x_object_version_number OUT NOCOPY NUMBER
925: ) IS
926: CURSOR is_employ_hist_id_exist(l_emp_hist_id NUMBER)IS
927: SELECT nvl(object_version_number,1), party_id
928: FROM HZ_EMPLOYMENT_HISTORY
929: WHERE employment_history_id = l_emp_hist_id
930: AND rownum = 1;
931:
932: CURSOR is_employ_hist_exist(l_party_id NUMBER, l_company VARCHAR2,

Line 935: FROM HZ_EMPLOYMENT_HISTORY

931:
932: CURSOR is_employ_hist_exist(l_party_id NUMBER, l_company VARCHAR2,
933: l_title VARCHAR2, l_begin_date DATE)IS
934: SELECT nvl(object_version_number,1), employment_history_id
935: FROM HZ_EMPLOYMENT_HISTORY
936: WHERE party_id = l_party_id
937: AND nvl(UPPER(ltrim(rtrim(employed_by_name_company))),-99) = nvl(UPPER(ltrim(rtrim(l_company))),-99)
938: AND nvl(UPPER(ltrim(rtrim(employed_as_title))),-99) = nvl(UPPER(ltrim(rtrim(l_title))), -99)
939: AND nvl(trunc(begin_date),sysdate) = nvl(trunc(l_begin_date),sysdate)

Line 2850: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY

2846:
2847: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2848: -- get all entities of person, for person, the possible entites are
2849: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,
2850: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY
2851: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,
2852: -- HZ_CONTACT_PREFERENCES
2853: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2854: p_bus_object.user_mandated_flag(i) = 'Y' AND