DBA Data[Home] [Help]

APPS.PA_BGT_BASELINE_PKG dependencies on PA_TASKS

Line 85: pa_tasks pt,

81: pb.burdened_cost
82: from
83: pa_budget_lines pb,
84: pa_resource_assignments pa,
85: pa_tasks pt,
86: pa_resource_list_members rm,
87: pa_budget_versions pbv
88: where pbv.budget_version_id = p_budget_version_id
89: and pa.resource_assignment_id = pb.resource_assignment_id

Line 760: pa_tasks pt

756: from pa_expenditure_items_all ei,
757: -- pa_expenditures_all exp, -- 7531681
758: pa_cost_distribution_lines_all cdl,
759: gl_period_STATUSES gl,
760: pa_tasks pt
761: where cdl.project_id = p_project_id
762: and pt.task_id = ei.task_id
763: -- and ei.expenditure_id = exp.expenditure_id -- 7531681
764: --and trunc(gl.end_date) = trunc(cdl.gl_date)

Line 957: pa_tasks pt

953: from pa_expenditure_items_all ei,
954: -- pa_expenditures_all exp, -- 7531681
955: pa_cost_distribution_lines_all cdl,
956: gl_period_STATUSES gl,
957: pa_tasks pt
958: where cdl.project_id = p_project_id
959: and pt.task_id = ei.task_id
960: -- and ei.expenditure_id = exp.expenditure_id -- 7531681
961: --and trunc(gl.end_date) = trunc(cdl.gl_date)

Line 1417: pa_tasks pt

1413: ,bc.reference3
1414: -- R12 Funds Management Uptake
1415: ,bc.burden_method_code
1416: from pa_bc_commitments_all bc,
1417: pa_tasks pt
1418: --,pa_budget_versions pbv,
1419: --pa_budget_types pbt
1420: where bc.project_id = p_project_id
1421: and pt.task_id = bc.task_id;