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_TERMINATION_SS dependencies on PER_ASSIGNMENTS_F2

Line 2994: per_Assignments_f2 paf,

2990: ppf.local_name LOCAL_NAME,
2991: ppf.global_name GLOBAL_NAME,
2992: ppf.npw_number
2993: from per_people_f ppf, -- from secured view for assign new report(bug1855111)
2994: per_Assignments_f2 paf,
2995: per_jobs_vl jbs,
2996: hr_all_organization_units_tl org,
2997: hr_all_organization_units_tl bus,
2998: hr_all_positions_f_vl pos,

Line 3027: from per_assignments_f2 paf2

3023: -- Replaced NOT IN clause with NOT EXISTS, Bug 2416631
3024: -- TO FILTER ALL DIRECT REPORTS TO THE PERSON
3025: (
3026: select paf2.person_id
3027: from per_assignments_f2 paf2
3028: where paf2.supervisor_id = cp_param_8
3029: and paf2.primary_flag in (cp_param_9 , cp_param_10)
3030: and paf2.assignment_type in ('E','C')
3031: and to_date(cp_param_11, 'YYYY-MM-DD') between paf2.effective_start_date and paf2.effective_end_date