eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_WF_PKG dependencies on PER_PEOPLE_F

Line 1367: from per_people_f per,

1363: select usr.employee_id,
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

Line 1380: FROM per_people_f per,

1376: SELECT usr.employee_id,
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

Line 1411: l_user_name_employee_id per_people_f.person_id%TYPE;

1407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%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;

Line 1412: l_user_name_emp_first_name per_people_f.first_name%TYPE;

1408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%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;

Line 1413: l_user_name_emp_last_name per_people_f.last_name%TYPE;

1409: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%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;

Line 1414: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

1410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%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: