APPS.AHL_PRD_NONROUTINE_PVT dependencies on FND_USER

Line 1293: FROM fnd_user

1289: AND trunc(nvl(csv.end_date_active,sysdate));
1290:
1291: CURSOR default_contact IS
1292: SELECT employee_id
1293: FROM fnd_user
1294: WHERE user_id = fnd_global.user_id;
1295:
1296: CURSOR default_customer_type IS
1297: SELECT party_type

Line 1585: -- Contact info from fnd_user.user_id

1581: --- End Changes
1582:
1583: -- If Customer id and Contact id is null then
1584: -- Derive the Customer info from Profile and
1585: -- Contact info from fnd_user.user_id
1586: IF ((p_x_sr_task_rec.customer_id IS NULL or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM ) and
1587: (p_x_sr_task_rec.contact_id IS NULL or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1588: IF ( fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME') is not null ) THEN
1589: