APPS.JTF_IH_PUB dependencies on PER_WORKFORCE_CURRENT_X
Line 121: SELECT DISTINCT PERSON_ID INTO s_Employee_Number FROM PER_WORKFORCE_CURRENT_X WHERE PARTY_ID = p_Party_id;
117: FUNCTION Is_ContactPartyEmployeeOfOrg(p_Party_id IN NUMBER
118: )RETURN BOOLEAN AS
119: s_Employee_Number VARCHAR2(30) := NULL;
120: BEGIN 121: SELECT DISTINCT PERSON_ID INTO s_Employee_Number FROM PER_WORKFORCE_CURRENT_X WHERE PARTY_ID = p_Party_id; 122: RETURN TRUE;
123: EXCEPTION
124: WHEN NO_DATA_FOUND THEN
125: RETURN FALSE;