APPS.WIP_OSP dependencies on FND_USER

Line 392: FROM FND_USER FU,

388: you are an employee. If this returns a row, you are OK */
389:
390: CURSOR Cemp IS
391: SELECT 'x'
392: FROM FND_USER FU,
393: PER_PEOPLE_F PPF
394: WHERE FU.USER_ID = FND_GLOBAL.User_Id
395: AND FU.EMPLOYEE_ID = PPF.PERSON_ID;
396:

Line 566: FND_USER fu, BOM_DEPARTMENTS bd,

562: FROM WIP_REPETITIVE_SCHEDULES wrs,
563: HR_ORGANIZATION_INFORMATION hoi,
564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we

Line 750: FND_USER fu, BOM_DEPARTMENTS bd,

746: FROM WIP_REPETITIVE_SCHEDULES wrs, /*MTL_ITEM_REVISIONS mir, */
747: HR_ORGANIZATION_INFORMATION hoi,
748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we

Line 1280: FROM fnd_user fu,

1276: )
1277: ))
1278: AND NOT EXISTS
1279: (SELECT 'Current user is an employee'
1280: FROM fnd_user fu,
1281: per_people_f ppf
1282: WHERE fu.user_id = c_user_id
1283: AND fu.employee_id = ppf.person_id);
1284: