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.BEN_PUMP_GET dependencies on PER_ALL_PEOPLE_F

Line 313: from per_all_people_f

309: ELSIF p_employee_number IS NOT NULL THEN
310: --
311: select person_id
312: into l_person_id
313: from per_all_people_f
314: where business_group_id = p_business_group_id
315: and p_effective_date between effective_start_date
316: and effective_end_date
317: and employee_number = p_employee_number ;

Line 323: from per_all_people_f

319: ELSIF p_national_identifier IS NOT NULL THEN
320: --
321: select person_id
322: into l_person_id
323: from per_all_people_f
324: where business_group_id = p_business_group_id
325: and p_effective_date between effective_start_date
326: and effective_end_date
327: and national_identifier = p_national_identifier ;

Line 333: from per_all_people_f

329: ELSIF p_full_name IS NOT NULL AND p_date_of_birth IS NOT NULL THEN
330: --
331: select person_id
332: into l_person_id
333: from per_all_people_f
334: where business_group_id = p_business_group_id
335: and p_effective_date between effective_start_date
336: and effective_end_date
337: and full_name = p_full_name

Line 380: from per_all_people_f

376: ELSIF p_con_employee_number IS NOT NULL THEN
377: --
378: select person_id
379: into l_person_id
380: from per_all_people_f
381: where business_group_id = p_business_group_id
382: and p_effective_date between effective_start_date
383: and effective_end_date
384: and employee_number = p_con_employee_number ;

Line 390: from per_all_people_f

386: ELSIF p_con_national_identifier IS NOT NULL THEN
387: --
388: select person_id
389: into l_person_id
390: from per_all_people_f
391: where business_group_id = p_business_group_id
392: and p_effective_date between effective_start_date
393: and effective_end_date
394: and national_identifier = p_con_national_identifier ;

Line 400: from per_all_people_f

396: ELSIF p_con_full_name IS NOT NULL AND p_con_date_of_birth IS NOT NULL THEN
397: --
398: select person_id
399: into l_person_id
400: from per_all_people_f
401: where business_group_id = p_business_group_id
402: and p_effective_date between effective_start_date
403: and effective_end_date
404: and full_name = p_con_full_name