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

Line 763: per_person_types ppt

759: --
760: CURSOR future_person_types IS
761: SELECT ppt.system_person_type
762: FROM per_people_f ppf,
763: per_person_types ppt
764: WHERE ppf.person_type_id = ppt.person_type_id
765: AND ppf.person_id = p_person_id
766: AND ppf.business_group_id + 0 = ppt.business_group_id + 0
767: AND p_action_date < ppf.effective_start_date;

Line 777: per_person_types ppt ,

773:
774: CURSOR fptypes_for_cwk1 IS
775: SELECT ppt.system_person_type
776: FROM
777: per_person_types ppt ,
778: per_person_type_usages_f pptf
779: WHERE
780: pptf.person_id = p_person_id
781: AND p_action_date < pptf.effective_start_date

Line 2264: FROM per_person_types

2260: INTO l_person_type_id
2261: , l_current_applicant_flag
2262: , l_current_employee_flag
2263: , l_current_emp_or_apl_flag
2264: FROM per_person_types
2265: WHERE business_group_id = p_business_group_id --#3735333
2266: AND default_flag = 'Y'
2267: AND active_flag = 'Y'
2268: AND ((c_emp_rec.current_applicant_flag = 'Y'