DBA Data[Home] [Help]

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;