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

Line 870: FROM pa_resources_denorm

866:
867: /* Added for Bug 6056112 */
868: CURSOR c_fut_term_org_id IS
869: SELECT RESOURCE_ORGANIZATION_ID
870: FROM pa_resources_denorm
871: WHERE person_id = v_person_id
872: AND TRUNC(resource_effective_start_date)<=TRUNC(NVL(p_start_date, resource_effective_start_date))
873: AND TRUNC(NVL(p_start_date,SYSDATE))<=TRUNC(resource_effective_end_date);
874:

Line 965: FROM pa_resources_denorm

961: SELECT 'Y'
962: INTO l_is_manager
963: FROM dual
964: WHERE p_manager_id IN ( SELECT Manager_id
965: FROM pa_resources_denorm
966: WHERE nvl(p_start_date, trunc(sysdate)) BETWEEN resource_effective_start_date
967: AND resource_effective_end_date
968: AND manager_id is not null
969: START WITH person_id = p_person_id

Line 985: FROM pa_resources_denorm WHERE

981:
982: LOOP
983: BEGIN
984: SELECT manager_id INTO l_mgr_id
985: FROM pa_resources_denorm WHERE
986: person_id = l_person_id
987: AND nvl(p_start_date, trunc(sysdate))
988: BETWEEN resource_effective_start_date AND resource_effective_end_date;
989: