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.

[Home] [Help]

APPS.GHR_WF_PKG dependencies on PER_PEOPLE_F

Line 1389: from per_people_f per,

1385: select usr.employee_id,
1386: per.first_name,
1387: per.last_name,
1388: per.middle_names
1389: from per_people_f per,
1390: fnd_user usr
1391: where upper(usr.user_name) = upper(p_user_name)
1392: and per.person_id = usr.employee_id
1393: and l_effective_date

Line 1402: FROM per_people_f per,

1398: SELECT usr.employee_id,
1399: per.first_name,
1400: per.last_name,
1401: per.middle_names
1402: FROM per_people_f per,
1403: fnd_user usr
1404: WHERE usr.user_name = upper(p_user_name)
1405: AND per.person_id = usr.employee_id
1406: AND l_effective_date

Line 1433: l_user_name_employee_id per_people_f.person_id%TYPE;

1429: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;

Line 1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;

1430: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

Line 1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;

1431: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

1432: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
1433: l_user_name_employee_id per_people_f.person_id%TYPE;
1434: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1435: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1436: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1437: l_current_user_name fnd_user.user_name%type;
1438: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
1439: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
1440: