APPS.GMS_BUDGET_CORE dependencies on PA_TASKS

Line 837: from pa_tasks t , gms_resource_assignments r

833: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');
834: END IF;
835:
836: for b1_rec in (select t.task_id, resource_assignment_id
837: from pa_tasks t , gms_resource_assignments r
838: where t.task_id = r.task_id
839: and r.budget_version_id = x_dest_version_id) loop
840:
841: -- Added the call to gms_budget_utils.get_valid_period_dates() for Bug: 2592747

Line 882: from pa_tasks t , gms_resource_assignments r

878: END IF;
879:
880: --following loop is for draft version
881: for b2_rec in (select t.task_id, resource_assignment_id
882: from pa_tasks t , gms_resource_assignments r
883: where t.task_id = r.task_id
884: and r.budget_version_id = x_draft_version_id) loop
885:
886: -- Added the call to gms_budget_utils.get_valid_period_dates() for Bug: 2592747

Line 1522: pa_tasks st,

1518: sa.unit_of_measure,
1519: sa.track_as_labor_flag
1520: from
1521: gms_resource_assignments sa,
1522: pa_tasks st,
1523: pa_tasks dt,
1524: gms_budget_versions dv
1525: where sa.budget_version_id = x_src_version_id
1526: and sa.project_id = st.project_id

Line 1523: pa_tasks dt,

1519: sa.track_as_labor_flag
1520: from
1521: gms_resource_assignments sa,
1522: pa_tasks st,
1523: pa_tasks dt,
1524: gms_budget_versions dv
1525: where sa.budget_version_id = x_src_version_id
1526: and sa.project_id = st.project_id
1527: and sa.task_id = st.task_id

Line 1596: from pa_tasks

1592: if (x_entry_level_code <> 'P') then
1593: x_err_stage := 'Getting Task Start Date <'|| to_char(x_src_version_id);
1594: select start_date
1595: into x_task_start_date
1596: from pa_tasks
1597: where task_id = budget_line_row.task_id;
1598: end if;
1599:
1600: x_err_stage := 'Getting no of periods by which line budget period needs to be shifted<'||

Line 1724: pa_tasks st,

1720: 'B',
1721: 'B'
1722: from gms_budget_lines l,
1723: gms_resource_assignments sa,
1724: pa_tasks st,
1725: pa_tasks dt,
1726: gms_resource_assignments da
1727: where l.resource_assignment_id =
1728: budget_line_row.resource_assignment_id

Line 1725: pa_tasks dt,

1721: 'B'
1722: from gms_budget_lines l,
1723: gms_resource_assignments sa,
1724: pa_tasks st,
1725: pa_tasks dt,
1726: gms_resource_assignments da
1727: where l.resource_assignment_id =
1728: budget_line_row.resource_assignment_id
1729: and l.start_date = budget_line_row.start_date

Line 1948: FROM pa_tasks

1944: INTO dummy
1945: FROM DUAL
1946: WHERE EXISTS (
1947: SELECT 1
1948: FROM pa_tasks
1949: WHERE project_id = x_project_id
1950: AND task_id = x_task_id
1951: AND task_id = top_task_id
1952: AND EXISTS (select 1

Line 1953: FROM pa_tasks

1949: WHERE project_id = x_project_id
1950: AND task_id = x_task_id
1951: AND task_id = top_task_id
1952: AND EXISTS (select 1
1953: FROM pa_tasks
1954: where nvl(parent_task_id,0) = x_task_id
1955: and project_id = x_project_id));
1956: exception
1957: when NO_DATA_FOUND then

Line 2590: from pa_tasks t

2586: elsif (x_entry_level_code = 'T') then
2587:
2588: -- go through every top level task
2589: for top_task_rec in (select t.task_id
2590: from pa_tasks t
2591: where t.project_id = x_project_id
2592: and t.task_id = t.top_task_id
2593: and EXISTS ( SELECT 1 -- added for bug 1831151
2594: FROM gms_balances gb

Line 2765: from pa_tasks t

2761:
2762: else -- 'L' or 'M'
2763: -- go through every lowest level task
2764: for task_rec in (select t.task_id
2765: from pa_tasks t
2766: where t.project_id = x_project_id
2767: and not exists
2768: (select 1
2769: from pa_tasks t1

Line 2769: from pa_tasks t1

2765: from pa_tasks t
2766: where t.project_id = x_project_id
2767: and not exists
2768: (select 1
2769: from pa_tasks t1
2770: where t1.parent_task_id = t.task_id)
2771: AND EXISTS ( SELECT 1 --bug 1831151
2772: FROM gms_balances
2773: WHERE budget_version_id =