APPS.PER_ZA_EE_WORKFORCE_PROFILE dependencies on HR_ORGANIZATION_INFORMATION
Line 19: FROM HR_ORGANIZATION_INFORMATION HOI
15:
16: FUNCTION GET_SETA_CLASSIFICATION(P_LEGAL_ENTITY_ID IN NUMBER,P_BUSINESS_GROUP_ID IN NUMBER) RETURN CHAR IS
17: CURSOR SETA_CLASS(P_ORG_ID IN NUMBER) IS
18: SELECT ORG_INFORMATION4 SETA_CLASSIFICATION 19: FROM HR_ORGANIZATION_INFORMATION HOI 20: WHERE HOI.ORGANIZATION_ID = P_ORG_ID
21: AND HOI.ORG_INFORMATION_CONTEXT = 'ZA_NQF_SETA_INFO';
22: BEGIN
23: FOR seta_rec IN SETA_CLASS(P_LEGAL_ENTITY_ID) LOOP