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.HR_PERSON_RECORD dependencies on PER_PERSON_TYPES

Line 242: per_person_types ppt,

238: CURRENT_NPW_FLAG,
239: GLOBAL_NAME,
240: LOCAL_NAME
241: FROM PER_PEOPLE_F ppf,
242: per_person_types ppt,
243: per_person_types_v pptl
244: where ppf.person_id = p_person_id
245: and ppf.business_group_id = p_business_group_id
246: and ppt.person_type_id = pptl.person_type_id

Line 243: per_person_types_v pptl

239: GLOBAL_NAME,
240: LOCAL_NAME
241: FROM PER_PEOPLE_F ppf,
242: per_person_types ppt,
243: per_person_types_v pptl
244: where ppf.person_id = p_person_id
245: and ppf.business_group_id = p_business_group_id
246: and ppt.person_type_id = pptl.person_type_id
247: and ppf.person_type_id = ppt.person_type_id

Line 2441: ,per_person_types ppt

2437: open srch_filtrd for
2438:
2439: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2440: from per_people_f ppf
2441: ,per_person_types ppt
2442: ,per_phones pp
2443: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2444: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2445: and ppf.person_id = pp.parent_id(+)

Line 2459: ,per_person_types ppt

2455: open srch_filtrd for
2456:
2457: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2458: from per_people_f ppf
2459: ,per_person_types ppt
2460: ,per_qualifications pq
2461: ,per_establishment_attendances pea
2462: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2463: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 2478: ,per_person_types ppt

2474: open srch_filtrd for
2475:
2476: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2477: from per_people_f ppf
2478: ,per_person_types ppt
2479: ,per_person_dlvry_methods ppdm
2480: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2481: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2482: and ppdm.person_id = ppf.person_id

Line 2495: ,per_person_types ppt

2491: open srch_filtrd for
2492:
2493: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2494: from per_people_f ppf
2495: ,per_person_types ppt
2496: ,per_addresses pa
2497: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2498: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2499: and pa.person_id = ppf.person_id

Line 2509: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf

2505: ELSE
2506: open srch_filtrd for
2507:
2508: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2509: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf
2510: where nvl(p_srch_criteria(i).p_person_id, ppf.person_id) = ppf.person_id
2511: and ppf.person_id between nvl(p_srch_criteria(i).p_start_person_id, ppf.person_id)
2512: and nvl(p_srch_criteria(i).p_end_person_id, ppf.person_id)
2513: and ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)