DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on PER_PEOPLE_X

Line 3181: -- Using per_people_x here, since it already has the inactive person check on per_people_f

3177: party_name = p_x_nonroutine_rec.contact_name;
3178: ELSIF (p_x_nonroutine_rec.contact_type = 'EMPLOYEE')
3179: THEN
3180: -- Bug #4918818: APPSPERF fix
3181: -- Using per_people_x here, since it already has the inactive person check on per_people_f
3182: -- Bug #9813087:
3183: -- Sreesubha -Added contact_id condition in where clause
3184: SELECT person_id
3185: INTO p_x_nonroutine_rec.contact_id

Line 3186: FROM per_people_x

3182: -- Bug #9813087:
3183: -- Sreesubha -Added contact_id condition in where clause
3184: SELECT person_id
3185: INTO p_x_nonroutine_rec.contact_id
3186: FROM per_people_x
3187: WHERE full_name = p_x_nonroutine_rec.contact_name and
3188: person_id = nvl(p_x_nonroutine_rec.contact_id,person_id);
3189: ELSE
3190: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_CONT_TYPE_INV');