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 2029: FROM pa_resources_denorm res,

2025: res.person_id resource_person_id,
2026: res.resource_id,
2027: hou.name resource_organization_name,
2028: res.manager_id
2029: FROM pa_resources_denorm res,
2030: hr_all_organization_units hou
2031: WHERE res.resource_id = l_resource_id
2032: AND hou.organization_id = res.resource_organization_id
2033: AND p_start_date BETWEEN resource_effective_start_date

Line 2689: FROM pa_resources_denorm

2685: l_resource_name VARCHAR2(240);
2686: BEGIN
2687: SELECT distinct(resource_name)
2688: INTO l_resource_name
2689: FROM pa_resources_denorm
2690: WHERE resource_id = p_resource_id
2691: AND rownum=1 -- 5345135
2692: ;
2693:

Line 2898: pa_resources_denorm res

2894: cand.nomination_date,
2895: cand.nomination_comments,
2896: cand.candidate_ranking
2897: FROM pa_candidates cand,
2898: pa_resources_denorm res
2899: WHERE assignment_id = p_old_requirement_id
2900: AND p_new_start_date BETWEEN
2901: res.resource_effective_start_date AND
2902: NVL(res.resource_effective_end_date, sysdate+1)