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_SUIT_MATCH_UTILITY_WEB dependencies on PER_SUCCESSION_PLANNING

Line 2712: FROM per_succession_planning psp,

2708:
2709: CURSOR csr_succession_by_person IS
2710: SELECT * FROM (
2711: SELECT psp.position_id, pp.name
2712: FROM per_succession_planning psp,
2713: hr_positions_f pp
2714: WHERE psp.person_id = p_person_id
2715: AND p_effective_date <= NVL(psp.end_date, p_effective_date)
2716: AND psp.position_id = pp.position_id

Line 2936: FROM per_succession_planning psp

2932: ,ppf.full_name name
2933: ,hr_person_type_usage_info.get_user_person_type
2934: (p_effective_date, ppf.person_id) type
2935: ,ppf.order_name
2936: FROM per_succession_planning psp
2937: ,per_people_f ppf
2938: WHERE psp.position_id = p_pos_id
2939: AND p_effective_date <=
2940: NVL(psp.end_date, p_effective_date)

Line 2972: FROM per_succession_planning psp

2968: ,hr_person_type_usage_info.get_user_person_type
2969: (p_effective_date, ppf.person_id) type
2970: ,ppf.last_name
2971: ,ppf.first_name
2972: FROM per_succession_planning psp
2973: ,per_people_f ppf
2974: WHERE psp.position_id = p_pos_id
2975: AND p_effective_date <=
2976: NVL(psp.end_date, p_effective_date)