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

Line 137: l_name per_people_f.full_name%type;

133: --
134: l_check_date date;
135: l_log_text varchar2(2000);
136: l_from_user_tab_name pay_user_tables.user_table_name%type;
137: l_name per_people_f.full_name%type;
138: l_ssn per_people_f.national_identifier%type;
139: --bug # 9329643
140: l_employee_number per_people_f.employee_number%type;
141: --

Line 138: l_ssn per_people_f.national_identifier%type;

134: l_check_date date;
135: l_log_text varchar2(2000);
136: l_from_user_tab_name pay_user_tables.user_table_name%type;
137: l_name per_people_f.full_name%type;
138: l_ssn per_people_f.national_identifier%type;
139: --bug # 9329643
140: l_employee_number per_people_f.employee_number%type;
141: --
142: --

Line 140: l_employee_number per_people_f.employee_number%type;

136: l_from_user_tab_name pay_user_tables.user_table_name%type;
137: l_name per_people_f.full_name%type;
138: l_ssn per_people_f.national_identifier%type;
139: --bug # 9329643
140: l_employee_number per_people_f.employee_number%type;
141: --
142: --
143: CURSOR cur_emp_det IS
144: SELECT per.full_name full_name

Line 148: from per_people_f per

144: SELECT per.full_name full_name
145: ,per.national_identifier national_identifier
146: --bug # 9329643
147: ,per.employee_number employee_number
148: from per_people_f per
149: ,per_assignments_f paf
150: where paf.person_id = per.person_id
151: and l_check_date
152: between paf.effective_start_date and paf.effective_end_date