APPS.PA_BUDGET_CORE1 dependencies on PA_TASKS

Line 1469: pa_tasks t

1465: l_start_date,
1466: l_end_date,
1467: l_task_id
1468: from pa_periods p,
1469: pa_tasks t
1470: where t.project_id = x_project_id
1471: and t.task_id = t.top_task_id
1472: and p.start_date between x_start_period_start_date
1473: and x_end_period_end_date;

Line 1510: pa_tasks

1506: AND pta.task_id IN
1507: (SELECT
1508: task_id
1509: FROM
1510: pa_tasks
1511: CONNECT BY PRIOR task_id = parent_task_id
1512: START WITH task_id = l_task_id(i)
1513: )
1514: AND EXISTS

Line 1551: pa_tasks t

1547: l_end_date,
1548: l_task_id
1549: from gl_period_statuses p,
1550: pa_implementations i,
1551: pa_tasks t
1552: where t.project_id = x_project_id
1553: and t.task_id = t.top_task_id
1554: and p.application_id = pa_period_process_pkg.application_id
1555: and p.set_of_books_id = i.set_of_books_id

Line 1595: pa_tasks

1591: AND pta.task_id IN
1592: (SELECT
1593: task_id
1594: FROM
1595: pa_tasks
1596: CONNECT BY PRIOR task_id = parent_task_id
1597: START WITH task_id = l_task_id(i)
1598: )
1599: AND EXISTS

Line 1862: pa_tasks t,

1858: l_resource_list_member_id,
1859: l_resource_id,
1860: l_track_as_labor_flag
1861: from pa_periods p,
1862: pa_tasks t,
1863: pa_resource_list_members m
1864: where m.resource_list_id = x_resource_list_id
1865: and nvl(m.migration_code, 'M') = 'M'
1866: and not exists

Line 1913: pa_tasks

1909: AND pta.task_id IN
1910: (SELECT
1911: task_id
1912: FROM
1913: pa_tasks
1914: CONNECT BY PRIOR task_id = parent_task_id
1915: START WITH task_id = l_task_id(i)
1916: )
1917: AND EXISTS

Line 1978: pa_tasks t,

1974: l_resource_id,
1975: l_track_as_labor_flag
1976: from gl_period_statuses p,
1977: pa_implementations i,
1978: pa_tasks t,
1979: pa_resource_list_members m
1980: where m.resource_list_id = x_resource_list_id
1981: and not exists
1982: (select 1

Line 2029: pa_tasks

2025: AND pta.task_id IN
2026: (SELECT
2027: task_id
2028: FROM
2029: pa_tasks
2030: CONNECT BY PRIOR task_id = parent_task_id
2031: START WITH task_id = l_task_id(i)
2032: )
2033: AND EXISTS

Line 2303: from pa_tasks t

2299: /* elsif (x_entry_level_code = 'T') then
2300:
2301: -- go through every top level task
2302: for top_task_rec in (select t.task_id
2303: from pa_tasks t
2304: where t.project_id = x_project_id
2305: and t.task_id = t.top_task_id) loop
2306:
2307: x_raw_cost:= 0;

Line 2645: pa_tasks t

2641: l_start_date,
2642: l_end_date,
2643: l_task_id
2644: from pa_periods p,
2645: pa_tasks t
2646: where t.project_id = x_project_id
2647: and not exists
2648: (select 1
2649: from pa_tasks t1

Line 2649: from pa_tasks t1

2645: pa_tasks t
2646: where t.project_id = x_project_id
2647: and not exists
2648: (select 1
2649: from pa_tasks t1
2650: where t1.parent_task_id = t.task_id)
2651: and p.start_date between x_start_period_start_date
2652: and x_end_period_end_date;
2653:

Line 2691: pa_tasks

2687: AND pta.task_id IN
2688: (SELECT
2689: task_id
2690: FROM
2691: pa_tasks
2692: CONNECT BY PRIOR task_id = parent_task_id
2693: START WITH task_id = l_task_id(i)
2694: )
2695: AND EXISTS

Line 2734: pa_tasks t

2730: l_end_date,
2731: l_task_id
2732: from gl_period_statuses p,
2733: pa_implementations i,
2734: pa_tasks t
2735: where t.project_id = x_project_id
2736: and not exists
2737: (select 1
2738: from pa_tasks t1

Line 2738: from pa_tasks t1

2734: pa_tasks t
2735: where t.project_id = x_project_id
2736: and not exists
2737: (select 1
2738: from pa_tasks t1
2739: where t1.parent_task_id = t.task_id)
2740: and p.application_id = pa_period_process_pkg.application_id
2741: and p.set_of_books_id = i.set_of_books_id
2742: and p.adjustment_period_flag = 'N'

Line 2781: pa_tasks

2777: AND pta.task_id IN
2778: (SELECT
2779: task_id
2780: FROM
2781: pa_tasks
2782: CONNECT BY PRIOR task_id = parent_task_id
2783: START WITH task_id = l_task_id(i)
2784: )
2785: AND EXISTS

Line 3054: pa_tasks t,

3050: l_resource_list_member_id,
3051: l_resource_id,
3052: l_track_as_labor_flag
3053: from pa_periods p,
3054: pa_tasks t,
3055: pa_resource_list_members m
3056: where m.resource_list_id = x_resource_list_id
3057: and nvl(m.migration_code, 'M') = 'M'
3058: and not exists

Line 3066: from pa_tasks t1

3062: m.resource_list_member_id)
3063: and t.project_id = x_project_id
3064: and not exists
3065: (select 1
3066: from pa_tasks t1
3067: where t1.parent_task_id = t.task_id)
3068: and p.start_date between x_start_period_start_date
3069: and x_end_period_end_date;
3070:

Line 3108: pa_tasks

3104: AND pta.task_id IN
3105: (SELECT
3106: task_id
3107: FROM
3108: pa_tasks
3109: CONNECT BY PRIOR task_id = parent_task_id
3110: START WITH task_id = l_task_id(i)
3111: )
3112: AND EXISTS

Line 3173: pa_tasks t,

3169: l_resource_id,
3170: l_track_as_labor_flag
3171: from gl_period_statuses p,
3172: pa_implementations i,
3173: pa_tasks t,
3174: pa_resource_list_members m
3175: where m.resource_list_id = x_resource_list_id
3176: and not exists
3177: (select 1

Line 3184: from pa_tasks t1

3180: m.resource_list_member_id)
3181: and t.project_id = x_project_id
3182: and not exists
3183: (select 1
3184: from pa_tasks t1
3185: where t1.parent_task_id = t.task_id)
3186: and p.application_id = pa_period_process_pkg.application_id
3187: and p.set_of_books_id = i.set_of_books_id
3188: and p.adjustment_period_flag = 'N'

Line 3227: pa_tasks

3223: AND pta.task_id IN
3224: (SELECT
3225: task_id
3226: FROM
3227: pa_tasks
3228: CONNECT BY PRIOR task_id = parent_task_id
3229: START WITH task_id = l_task_id(i)
3230: )
3231: AND EXISTS

Line 3501: from pa_tasks t

3497: end if;
3498: /* End of part 4 for BUg 4889056 */
3499: /* Begin of commented code
3500: for task_rec in (select t.task_id
3501: from pa_tasks t
3502: where t.project_id = x_project_id
3503: and not exists
3504: (select 1
3505: from pa_tasks t1

Line 3505: from pa_tasks t1

3501: from pa_tasks t
3502: where t.project_id = x_project_id
3503: and not exists
3504: (select 1
3505: from pa_tasks t1
3506: where t1.parent_task_id = t.task_id)
3507:
3508: ) loop
3509: