APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1167: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra

1163: FROM pa_control_items pci, pa_ci_actions pcia
1164: WHERE pci.project_id = p_project_id
1165: AND pcia.ci_id(+) = pci.ci_id
1166: AND pcia.ci_action_number(+) = pci.open_action_num
1167: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra
1168: WHERE pbv.project_id = pci.project_Id
1169: AND pbv.ci_id = pci.ci_id
1170: AND pra.budget_version_id = pbv.budget_version_id
1171: AND pra.project_id = p_project_id

Line 1561: pa_resource_assignments pra where

1557:
1558: -- Cursor to find out all unapproved tasks referred in one particular Change Document.
1559: CURSOR C1 IS
1560: Select distinct task_id from
1561: pa_resource_assignments pra where
1562: budget_version_id in (
1563: select budget_version_id from pa_budget_versions where ci_id = l_ci_id )
1564: and exists (select 1
1565: from pa_proj_elements ppe,

Line 1885: DELETE FROM PA_RESOURCE_ASSIGNMENTS

1881: ,avalue => l_content_id
1882: );
1883: END IF;
1884:
1885: DELETE FROM PA_RESOURCE_ASSIGNMENTS
1886: WHERE project_id = l_project_id
1887: AND task_id = c_task_info_rec.task_id;
1888:
1889: log_message('Before calling PA_TASK_PUB1.Delete_Task_Version',3);