APPS.OTA_INITIALIZATION_WF dependencies on FND_USER

Line 89: fnd_user

85: CURSOR C_person
86: IS
87: SELECT user_name
88: FROM
89: fnd_user
90: WHERE
91: employee_id = l_owner_id
92: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
93:

Line 200: FND_USER

196: IS
197: SELECT
198: USER_NAME
199: FROM
200: FND_USER
201: WHERE
202: employee_id = p_owner_id
203: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
204:

Line 535: FND_USER

531: CURSOR C_USER IS
532: SELECT
533: USER_NAME
534: FROM
535: FND_USER
536: WHERE
537: Employee_id = p_owner_id
538: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
539:

Line 1323: l_supervisor_username fnd_user.user_name%TYPE;

1319:
1320: l_creator_person_id per_all_people_f.person_id%type;
1321:
1322: l_supervisor_id per_all_people_f.person_id%Type;
1323: l_supervisor_username fnd_user.user_name%TYPE;
1324: l_supervisor_full_name per_all_people_f.full_name%TYPE;
1325:
1326: l_role_name wf_roles.name%type;
1327: l_role_display_name wf_roles.display_name%type;

Line 1335: fnd_user

1331: cursor curr_per_info
1332: is
1333: Select user_id ,user_name
1334: from
1335: fnd_user
1336: where employee_id=p_person_id
1337: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
1338:
1339: -- get creator person's person id

Line 1344: FND_USER

1340: CURSOR C_USER IS
1341: SELECT
1342: EMPLOYEE_ID
1343: FROM
1344: FND_USER
1345: WHERE
1346: user_id = l_creator_user_id ;
1347:
1348: -- get full name

Line 1372: FROM fnd_user

1368:
1369: -- get supervisor full name
1370: CURSOR csr_supervisor_user IS
1371: SELECT user_name
1372: FROM fnd_user
1373: WHERE employee_id= l_supervisor_id
1374: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
1375:
1376: