APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_WORK_CLASS

Line 989: FROM HZ_WORK_CLASS

985: x_object_version_number OUT NOCOPY NUMBER
986: ) IS
987: CURSOR is_work_class_id_exist(l_work_class_id NUMBER)IS
988: SELECT nvl(object_version_number,1), employment_history_id
989: FROM HZ_WORK_CLASS
990: WHERE work_class_id = l_work_class_id
991: AND rownum = 1;
992:
993: CURSOR is_work_class_exist(l_employ_hist_id NUMBER, l_work_class_name VARCHAR2)IS

Line 995: FROM HZ_WORK_CLASS

991: AND rownum = 1;
992:
993: CURSOR is_work_class_exist(l_employ_hist_id NUMBER, l_work_class_name VARCHAR2)IS
994: SELECT nvl(object_version_number,1), work_class_id
995: FROM HZ_WORK_CLASS
996: WHERE employment_history_id = l_employ_hist_id
997: AND UPPER(ltrim(rtrim(WORK_CLASS_NAME))) = UPPER(ltrim(rtrim(l_work_class_name)))
998: AND status in ('A','I')
999: AND rownum = 1;

Line 2899: p_bus_object.entity_name(i) = 'HZ_WORK_CLASS' AND

2895: WHEN p_bus_object.child_bo_code(i) = 'EMP_HIST' THEN
2896: l_emp_hist := TRUE;
2897: END CASE;
2898: ELSIF(p_bus_object.business_object_code(i) = 'EMP_HIST' AND
2899: p_bus_object.entity_name(i) = 'HZ_WORK_CLASS' AND
2900: p_bus_object.user_mandated_flag(i) = 'Y') THEN
2901: l_work_class := TRUE;
2902: END IF;
2903: END LOOP;