APPS.PA_SECURITY_PVT dependencies on PA_RESOURCES_DENORM

Line 859: FROM pa_resources_denorm

855:
856: /* Added for Bug 6056112 */
857: CURSOR c_fut_term_org_id IS
858: SELECT RESOURCE_ORGANIZATION_ID
859: FROM pa_resources_denorm
860: WHERE person_id = v_person_id
861: AND TRUNC(resource_effective_start_date)<=TRUNC(NVL(p_start_date, resource_effective_start_date))
862: AND TRUNC(NVL(p_start_date,SYSDATE))<=TRUNC(resource_effective_end_date);
863:

Line 954: FROM pa_resources_denorm

950: SELECT 'Y'
951: INTO l_is_manager
952: FROM dual
953: WHERE p_manager_id IN ( SELECT Manager_id
954: FROM pa_resources_denorm
955: WHERE nvl(p_start_date, trunc(sysdate)) BETWEEN resource_effective_start_date
956: AND resource_effective_end_date
957: AND manager_id is not null
958: START WITH person_id = p_person_id

Line 974: FROM pa_resources_denorm WHERE

970:
971: LOOP
972: BEGIN
973: SELECT manager_id INTO l_mgr_id
974: FROM pa_resources_denorm WHERE
975: person_id = l_person_id
976: AND nvl(p_start_date, trunc(sysdate))
977: BETWEEN resource_effective_start_date AND resource_effective_end_date;
978: