APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 819: from pa_resource_assignments

815: if (nvl(g_res_pa_task_assignment_id(i),PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
816: <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
817:
818: select count(*) into t_crt_count
819: from pa_resource_assignments
820: where resource_assignment_id = g_res_pa_task_assignment_id(i);
821:
822: log_pvt('MAIN','t_crt_count : '||t_crt_count);
823:

Line 2571: from pa_resource_assignments res1 , pa_budget_versions bud1 , PA_PROJ_ELEMENT_VERSIONS a

2567: log_pvt('DEL_RES','Before select '|| l_res_id_tbl.count);
2568:
2569: Select res1.resource_assignment_id , res1.task_id , a.element_version_id bulk collect
2570: into l_del_res_id_tbl, l_del_task_id_tbl, l_del_task_ver_id_tbl
2571: from pa_resource_assignments res1 , pa_budget_versions bud1 , PA_PROJ_ELEMENT_VERSIONS a
2572: where bud1.project_structure_version_id = P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2573: and bud1.budget_version_id = res1.budget_version_id
2574: and a.proj_element_id = res1.task_id
2575: and a.parent_structure_version_id = bud1.project_structure_version_id