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_PEOPLE_F

Line 241: FROM PER_PEOPLE_F ppf,

237: NPW_NUMBER,
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

Line 478: , (SELECT FULL_NAME FROM PER_PEOPLE_F

474: -- cursor to fetch the contact information
475: CURSOR csr_contact_record(p_person_id number,p_business_group_id number,p_eff_date date) is
476: SELECT CONTACT_RELATIONSHIP_ID
477: , CONTACT_PERSON_ID
478: , (SELECT FULL_NAME FROM PER_PEOPLE_F
479: WHERE PERSON_ID = CONTACT_PERSON_ID
480: AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
481: AND P_EFF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) CONTACT_FULL_NAME
482: , CONTACT_TYPE

Line 1436: FROM per_assignments_f papf , per_people_f ppf

1432: papf.assignment_status_type_id,
1433: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1434: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id
1435: AND LANGUAGE = USERENV('LANG')) REPORTEE_ASG_STATUS_DESC
1436: FROM per_assignments_f papf , per_people_f ppf
1437: WHERE
1438: p_eff_date BETWEEN papf.effective_start_date AND papf.effective_end_date
1439: and p_eff_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1440: and papf.business_group_id = P_BUSINESS_GROUP_ID

Line 1524: per_people_f ppf,

1520: from ben_elig_per_elctbl_chc epe,
1521: ben_prtt_enrt_rslt_f pen,
1522: ben_elig_cvrd_dpnt_f pdp,
1523: per_contact_relationships pcr,
1524: per_people_f ppf,
1525: ben_pl_typ_f plt,
1526: ben_pl_f pln,
1527: ben_opt_f opt,
1528: ben_oipl_f oipl,

Line 1615: from per_people_f ppf,

1611: pen.plip_ordr_num plip_ordr_num,
1612: pen.pl_ordr_num pl_ordr_num,
1613: pen.oipl_ordr_num oipl_ordr_num,
1614: pen.bnft_ordr_num bnft_ordr_num
1615: from per_people_f ppf,
1616: per_contact_relationships pcr,
1617: ben_prtt_enrt_rslt_f pen,
1618: ben_pl_bnf_f pbn,
1619: ben_pl_typ_f plt,

Line 1958: ,per_people_f ppf

1954: , paf.location_id
1955: from pay_payroll_actions ppa
1956: ,pay_assignment_actions paa
1957: ,per_assignments_f paf
1958: ,per_people_f ppf
1959: ,hr_lookups hl
1960: where ppa.action_type = 'X'
1961: and ppa.action_status = 'C'
1962: and ppa.report_type = hl.meaning

Line 2440: from per_people_f ppf

2436: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

Line 2458: from per_people_f ppf

2454: AND p_srch_criteria(i).p_person_id IS NULL THEN
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)

Line 2477: from per_people_f ppf

2473: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

Line 2494: from per_people_f ppf

2490: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

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)