DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_EMPLOYEES

Line 625: FROM pa_employees

621: BEGIN
622: IF p_resource_name IS NOT NULL THEN
623: BEGIN
624: SELECT person_id INTO l_resource_id
625: FROM pa_employees
626: WHERE full_name = p_resource_name
627: AND active = '*';
628: RETURN l_resource_id;
629: EXCEPTION WHEN NO_DATA_FOUND THEN