DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on FND_USER

Line 1430: FROM fnd_user

1426: AND trunc(nvl(csv.end_date_active,sysdate));
1427:
1428: CURSOR default_contact IS
1429: SELECT employee_id
1430: FROM fnd_user
1431: WHERE user_id = fnd_global.user_id;
1432:
1433: CURSOR default_customer_type IS
1434: SELECT party_type

Line 1748: -- Contact info from fnd_user.user_id

1744: --- End Changes
1745:
1746: -- If Customer id and Contact id is null then
1747: -- Derive the Customer info from Profile and
1748: -- Contact info from fnd_user.user_id
1749: IF ((p_x_sr_task_rec.customer_id IS NULL or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM ) and
1750: (p_x_sr_task_rec.contact_id IS NULL or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1751: IF ( fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME') is not null ) THEN
1752: