DBA Data[Home] [Help]

APPS.PA_TASK_PUB1 dependencies on PA_BUDGET_VERSIONS

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

17155: FROM pa_control_items pci, pa_ci_actions pcia
17156: WHERE pci.project_id = p_project_id
17157: AND pcia.ci_id = pci.ci_id
17158: AND pcia.ci_action_number = pci.open_action_num
17159: AND EXISTS (SELECT 1 FROM pa_budget_versions pbv, pa_resource_assignments pra
17160: WHERE pbv.project_id = pci.project_Id
17161: AND pbv.ci_id = pci.ci_id
17162: AND pra.budget_version_id = pbv.budget_version_id
17163: AND pra.project_id = p_project_id