DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_TASKS

Line 288: ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895

284:
285: PROCEDURE get_org_task_info
286: ( p_project_id IN pa_projects_all.project_id%TYPE
287: := NULL
288: ,x_org_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
289: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
290: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
291: ,x_err_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
292: ) is

Line 299: FROM pa_tasks pt

295:
296: CURSOR own_task IS
297: SELECT pt.task_id,
298: pt.carrying_out_organization_id
299: FROM pa_tasks pt
300: WHERE pt.project_id = p_project_id;
301:
302: l_stage NUMBER := 0;
303: