APPS.WIP_OSP dependencies on FND_USER

Line 427: FROM FND_USER FU,

423: you are an employee. If this returns a row, you are OK */
424:
425: CURSOR Cemp IS
426: SELECT 'x'
427: FROM FND_USER FU,
428: PER_PEOPLE_F PPF
429: WHERE FU.USER_ID = FND_GLOBAL.User_Id
430: AND FU.EMPLOYEE_ID = PPF.PERSON_ID;
431:

Line 614: FND_USER fu, BOM_DEPARTMENTS bd,

610: FROM WIP_REPETITIVE_SCHEDULES wrs,
611: HR_ORGANIZATION_INFORMATION hoi,
612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we

Line 807: FND_USER fu, BOM_DEPARTMENTS bd,

803: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
804: HR_ORGANIZATION_INFORMATION hoi,
805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we

Line 1366: FROM fnd_user fu,

1362: )
1363: ))
1364: AND NOT EXISTS
1365: (SELECT 'Current user is an employee'
1366: FROM fnd_user fu,
1367: per_people_f ppf
1368: WHERE fu.user_id = c_user_id
1369: AND fu.employee_id = ppf.person_id);
1370: