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.GHR_MASS_SEL_NOA dependencies on PER_ALL_ASSIGNMENTS_F

Line 961: per_all_assignments_f asg

957: cursor c_user_status is
958: select ast.user_status
959: from
960: per_assignment_status_types ast,
961: per_all_assignments_f asg
962: where asg.assignment_id = p_assignment_id
963: and ast.assignment_status_type_id = asg.assignment_status_type_id
964: and p_effective_date
965: between asg.effective_start_date

Line 4474: FROM per_all_assignments_f asg

4470: --Begin Bug# 16083971
4471: l_organization_id per_assignments_f.organization_id%TYPE;
4472: CURSOR c_org_id(l_per_id in per_assignments_f.person_id%TYPE) IS
4473: SELECT asg.organization_id
4474: FROM per_all_assignments_f asg
4475: WHERE asg.person_id = l_per_id
4476: AND asg.assignment_type <> 'B'
4477: AND trunc(p_effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
4478: ORDER BY asg.assignment_id;