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

Line 113: per_all_people_f per,

109: from fii_ccc_mgr_gt gt,
110: hr_all_organization_units org,
111: fnd_flex_values com,
112: fnd_flex_values cc,
113: per_all_people_f per,
114: hr_organization_information hoi
115: where gt.company_id = p_com_id
116: and gt.cost_center_id = p_cc_id
117: and gt.ccc_org_id = org.organization_id

Line 582: per_all_people_f per2

578: sysdate + 1 ) >= sysdate)
579: and org_information2 is not null
580: ) mgr_tbl,
581: hr_all_organization_units org,
582: per_all_people_f per2
583: where org.organization_id = mgr_tbl.organization_id
584: and per2.person_id = mgr_tbl.org_information2
585: and not exists (select 1
586: from per_all_people_f per

Line 586: from per_all_people_f per

582: per_all_people_f per2
583: where org.organization_id = mgr_tbl.organization_id
584: and per2.person_id = mgr_tbl.org_information2
585: and not exists (select 1
586: from per_all_people_f per
587: where per.person_id = mgr_tbl.org_information2
588: and per.effective_end_date > sysdate);
589:
590: CURSOR mgr_status_cur IS

Line 602: per_all_people_f per

598: sysdate + 1 ) >= sysdate)
599: and org_information2 is not null) ct,
600: hri_cs_suph suph,
601: per_assignment_status_types ast,
602: per_all_people_f per
603: where ct.org_information2 = suph.sub_person_id
604: and per.person_id = suph.sub_person_id
605: and sysdate between suph.effective_start_date
606: and suph.effective_end_date