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_CANDIDATE_PUB dependencies on PA_RESOURCES_DENORM

Line 1775: FROM pa_resources_denorm res,

1771: res.person_id resource_person_id,
1772: res.resource_id,
1773: hou.name resource_organization_name,
1774: res.manager_id
1775: FROM pa_resources_denorm res,
1776: hr_all_organization_units hou
1777: WHERE res.resource_id = l_resource_id
1778: AND hou.organization_id = res.resource_organization_id
1779: AND p_start_date BETWEEN resource_effective_start_date

Line 2426: FROM pa_resources_denorm

2422: l_resource_name VARCHAR2(240);
2423: BEGIN
2424: SELECT distinct(resource_name)
2425: INTO l_resource_name
2426: FROM pa_resources_denorm
2427: WHERE resource_id = p_resource_id
2428: AND rownum=1 -- 5345135
2429: ;
2430:

Line 2635: pa_resources_denorm res

2631: cand.nomination_date,
2632: cand.nomination_comments,
2633: cand.candidate_ranking
2634: FROM pa_candidates cand,
2635: pa_resources_denorm res
2636: WHERE assignment_id = p_old_requirement_id
2637: AND p_new_start_date BETWEEN
2638: res.resource_effective_start_date AND
2639: NVL(res.resource_effective_end_date, sysdate+1)