APPS.GHR_WF_PKG dependencies on FND_USER

Line 1353: ,fnd_user use

1349: ,pei.pei_information8 approver_flag
1350: ,pei.pei_information9 reviewer_flag
1351: ,pei.person_id person_id
1352: FROM per_people_extra_info pei
1353: ,fnd_user use
1354: WHERE use.user_name = p_user_name
1355: AND pei.person_id = use.employee_id
1356: AND pei.information_type = 'GHR_US_PER_WF_ROUTING_GROUPS'
1357: AND pei.pei_information3 = ( SELECT routing_group_id from

Line 1368: fnd_user usr

1364: per.first_name,
1365: per.last_name,
1366: per.middle_names
1367: from per_people_f per,
1368: fnd_user usr
1369: where upper(usr.user_name) = upper(p_user_name)
1370: and per.person_id = usr.employee_id
1371: and l_effective_date
1372: between effective_start_date

Line 1381: fnd_user usr

1377: per.first_name,
1378: per.last_name,
1379: per.middle_names
1380: FROM per_people_f per,
1381: fnd_user usr
1382: WHERE usr.user_name = upper(p_user_name)
1383: AND per.person_id = usr.employee_id
1384: AND l_effective_date
1385: BETWEEN effective_start_date

Line 1415: l_current_user_name fnd_user.user_name%type;

1411: l_user_name_employee_id per_people_f.person_id%TYPE;
1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1414: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1415: l_current_user_name fnd_user.user_name%type;
1416: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1417: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1418:
1419: l_result varchar2(4000);