APPS.OTA_COMPETENCE_SS dependencies on FND_USER

Line 1444: l_supervisor_username fnd_user.user_name%TYPE;

1440:
1441: l_assignment varchar2(100);
1442:
1443: l_supervisor_id per_all_people_f.person_id%Type;
1444: l_supervisor_username fnd_user.user_name%TYPE;
1445: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1446:
1447: l_event_name ota_events.title%type;
1448:

Line 1468: fnd_user

1464: cursor curr_per_info
1465: is
1466: Select user_id ,user_name
1467: from
1468: fnd_user
1469: where employee_id=p_person_id;
1470:
1471: CURSOR C_USER IS
1472: SELECT

Line 1475: FND_USER

1471: CURSOR C_USER IS
1472: SELECT
1473: EMPLOYEE_ID
1474: FROM
1475: FND_USER
1476: WHERE
1477: user_id = l_creator_user_id ;
1478:
1479: Cursor C_Assignment is

Line 1522: FROM fnd_user

1518: BETWEEN per.effective_start_date AND per.effective_end_date;
1519:
1520: CURSOR csr_supervisor_user IS
1521: SELECT user_name
1522: FROM fnd_user
1523: WHERE employee_id= l_supervisor_id;
1524:
1525: Cursor csr_name is
1526: select oev.title,oav.version_name