APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_CI_ACTIONS

Line 1163: FROM pa_control_items pci, pa_ci_actions pcia

1159: -- and are in SUBMITTED status.
1160: CURSOR C3(p_project_id NUMBER, p_task_id NUMBER) IS
1161: SELECT pci.ci_id,
1162: pcia.ci_action_id action_id
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