APPS.PA_SECURITY_PVT dependencies on PA_RESOURCES

Line 841: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112

837: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
838: x_error_message_code OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
839: v_person_id NUMBER;
840: v_org_id NUMBER;
841: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
842:
843: --If p_start_date is null, the cursor will select org_id from
844: --the first assignment available from sysdate
845: -- Bug 2911451 - Included condition for Assignment_type ='E'

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 871: FROM pa_resources

867:
868: /* Added for Bug 6056112 */
869: SELECT nvl(future_term_wf_flag,'N')
870: INTO l_future_term_wf_flag
871: FROM pa_resources
872: WHERE resource_id = p_resource_id;
873:
874: OPEN c_org_id;
875: FETCH c_org_id INTO x_resource_org_id;

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: