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 3054: pa_project_statuses ps

3050: CURSOR get_nominations(l_resource_id IN NUMBER) IS
3051: select cand.candidate_id, cand.record_version_number
3052: from pa_candidates cand,
3053: pa_project_assignments asgmt,
3054: pa_project_statuses ps
3055: where cand.resource_id = l_resource_id
3056: and cand.assignment_id = asgmt.assignment_id
3057: and asgmt.assignment_type = 'OPEN_ASSIGNMENT'
3058: and asgmt.status_code = ps.project_status_code (+)

Line 3064: from pa_project_statuses ps2

3060: OR ps.project_system_status_code is null)
3061: and asgmt.start_date > trunc(p_effective_date)
3062: and cand.status_code not in
3063: (select ps2.project_status_code
3064: from pa_project_statuses ps2
3065: where ps2.status_type='CANDIDATE'
3066: and ps2.project_system_status_code IN
3067: ('CANDIDATE_DECLINED','CANDIDATE_WITHDRAWN'));
3068: