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_PDI_API dependencies on PER_PEOPLE_F

Line 80: l_user_name_employee_id per_people_f.person_id%TYPE;

76: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;

Line 81: l_user_name_emp_first_name per_people_f.first_name%TYPE;

77: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;

Line 82: l_user_name_emp_last_name per_people_f.last_name%TYPE;

78: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

Line 83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

79: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
80: l_user_name_employee_id per_people_f.person_id%TYPE;
81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;

Line 98: from per_people_f per,

94: select usr.employee_id,
95: per.first_name,
96: per.last_name,
97: per.middle_names
98: from per_people_f per,
99: fnd_user usr
100: where upper(usr.user_name) = upper(p_1_user_name_acted_on)
101: and per.person_id = usr.employee_id
102: and p_date_from

Line 112: FROM per_people_f per,

108: SELECT usr.employee_id,
109: per.first_name,
110: per.last_name,
111: per.middle_names
112: FROM per_people_f per,
113: fnd_user usr
114: WHERE usr.user_name = UPPER(p_1_user_name_acted_on)
115: AND per.person_id = usr.employee_id
116: AND p_date_from

Line 625: l_user_name_employee_id per_people_f.person_id%TYPE;

621: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

Line 626: l_user_name_emp_first_name per_people_f.first_name%TYPE;

622: l_requester_flag ghr_pd_routing_history.requester_flag%TYPE;
623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

Line 627: l_user_name_emp_last_name per_people_f.last_name%TYPE;

623: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;

Line 628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

624: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
625: l_user_name_employee_id per_people_f.person_id%TYPE;
626: l_user_name_emp_first_name per_people_f.first_name%TYPE;
627: l_user_name_emp_last_name per_people_f.last_name%TYPE;
628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;

Line 672: per_people_f per

668: per.first_name,
669: per.last_name,
670: per.middle_names
671: FROM fnd_user usr,
672: per_people_f per
673: WHERE upper(p_u_user_name_acted_on) = upper(usr.user_name)
674: AND per.person_id = usr.employee_id
675: AND p_date_from
676: BETWEEN per.effective_start_date

Line 686: per_people_f per

682: per.first_name,
683: per.last_name,
684: per.middle_names
685: FROM fnd_user usr,
686: per_people_f per
687: WHERE usr.user_name = UPPER(p_u_user_name_acted_on)
688: AND per.person_id = usr.employee_id
689: AND p_date_from
690: BETWEEN per.effective_start_date

Line 1327: l_user_name_employee_id per_people_f.person_id%TYPE;

1323: l_authorizer_flag ghr_pd_routing_history.authorizer_flag%TYPE;
1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;

Line 1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;

1324: l_approver_flag ghr_pd_routing_history.approver_flag%TYPE;
1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;

Line 1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;

1325: l_approved_flag ghr_pd_routing_history.approved_flag%TYPE;
1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

Line 1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

1326: l_personnelist_flag ghr_pd_routing_history.personnelist_flag%TYPE;
1327: l_user_name_employee_id per_people_f.person_id%TYPE;
1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;