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.PA_HR_UPDATE_API dependencies on PA_PROJECT_STATUSES

Line 3047: pa_project_statuses ps

3043: CURSOR get_nominations(l_resource_id IN NUMBER) IS
3044: select cand.candidate_id, cand.record_version_number
3045: from pa_candidates cand,
3046: pa_project_assignments asgmt,
3047: pa_project_statuses ps
3048: where cand.resource_id = l_resource_id
3049: and cand.assignment_id = asgmt.assignment_id
3050: and asgmt.assignment_type = 'OPEN_ASSIGNMENT'
3051: and asgmt.status_code = ps.project_status_code (+)

Line 3057: from pa_project_statuses ps2

3053: OR ps.project_system_status_code is null)
3054: and asgmt.start_date > trunc(p_effective_date)
3055: and cand.status_code not in
3056: (select ps2.project_status_code
3057: from pa_project_statuses ps2
3058: where ps2.status_type='CANDIDATE'
3059: and ps2.project_system_status_code IN
3060: ('CANDIDATE_DECLINED','CANDIDATE_WITHDRAWN'));
3061: