APPS.PA_SECURITY_PVT dependencies on PA_RESOURCES

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

848: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
849: x_error_message_code OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
850: v_person_id NUMBER;
851: v_org_id NUMBER;
852: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
853:
854: --If p_start_date is null, the cursor will select org_id from
855: --the first assignment available from sysdate
856: -- Bug 2911451 - Included condition for Assignment_type ='E'

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

878:
879: /* Added for Bug 6056112 */
880: SELECT nvl(future_term_wf_flag,'N')
881: INTO l_future_term_wf_flag
882: FROM pa_resources
883: WHERE resource_id = p_resource_id;
884:
885: OPEN c_org_id;
886: FETCH c_org_id INTO x_resource_org_id;

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: