APPS.PA_TASK_PUB1 dependencies on PA_CI_ACTIONS

Line 17155: FROM pa_control_items pci, pa_ci_actions pcia

17151:
17152: CURSOR C3(p_project_id NUMBER, p_task_id NUMBER) IS
17153: SELECT pci.ci_id,
17154: pcia.ci_action_id action_id
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