APPS.GMS_PA_API3 dependencies on PA_TASKS

Line 2480: FROM pa_tasks task

2476: request_id = x_request_id
2477: WHERE ind_compiled_set_id = p_compiled_set_id
2478: AND EXISTS
2479: (SELECT task_id
2480: FROM pa_tasks task
2481: WHERE task.task_id = ei.task_id
2482: AND task.cost_ind_sch_fixed_date BETWEEN p_start_date AND
2483: NVL(p_end_date, cost_ind_sch_fixed_date))
2484: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'

Line 2507: FROM pa_tasks task

2503: AND trunc(encumbrance_item_date) between trunc(p_start_date) and
2504: trunc(nvl(p_end_date, encumbrance_item_date))
2505: AND EXISTS
2506: (SELECT task_id
2507: FROM pa_tasks task
2508: WHERE task.task_id = ei.task_id
2509: AND task.cost_ind_sch_fixed_date IS NULL)
2510: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2511: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'

Line 2664: pa_tasks TASK

2660: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2661: /* calling new function item_task_validate */
2662: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2663: from GMS_OVERRIDE_SCHEDULES GOS,
2664: pa_tasks TASK
2665: where GOS.award_id = p_award_id
2666: and GOS.project_id = p_project_id
2667: and nvl(ITEM.task_id,-99) = TASK.task_id
2668: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2672: from pa_tasks

2668: and nvl(GOS.task_id,-99) = TASK.top_task_id
2669: and rownum = 1) ,2
2670: ,1)
2671: ,decode((select top_task_id
2672: from pa_tasks
2673: where task_id = ITEM.task_id), p_task_id ,1
2674: ,2))*/
2675: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2676: AND l_project_closed <>'Y' --bug 7225876

Line 2733: pa_tasks TASK

2729: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2730: AND NOT EXISTS
2731: ( select 1
2732: from GMS_OVERRIDE_SCHEDULES GOS,
2733: pa_tasks TASK
2734: where GOS.award_id = p_award_id
2735: and GOS.project_id = ITEM.project_id
2736: and ITEM.task_id = TASK.task_id
2737: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id);

Line 2773: pa_tasks TASK

2769: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2770: /* calling new function item_task_validate */
2771: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2772: from GMS_OVERRIDE_SCHEDULES GOS,
2773: pa_tasks TASK
2774: where GOS.award_id = p_award_id
2775: and GOS.project_id = p_project_id
2776: and nvl(ITEM.task_id,-99) = TASK.task_id
2777: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2781: from pa_tasks

2777: and nvl(GOS.task_id,-99) = TASK.top_task_id
2778: and rownum = 1) ,2
2779: ,1)
2780: ,decode((select top_task_id
2781: from pa_tasks
2782: where task_id = ITEM.task_id), p_task_id ,1
2783: ,2))*/
2784: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2785: AND l_project_closed <>'Y' --bug 7225876

Line 2837: pa_tasks TASK

2833: AND ITEM.ind_compiled_set_id >0 -- bug 7225876
2834: AND NOT EXISTS
2835: ( select 1
2836: from GMS_OVERRIDE_SCHEDULES GOS,
2837: pa_tasks TASK
2838: where GOS.award_id = p_award_id
2839: and GOS.project_id = ITEM.project_id
2840: and TASK.task_id = item.task_id
2841: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id);

Line 2908: pa_tasks TASK

2904: l_test := 0;
2905: select 1
2906: into l_test
2907: from GMS_OVERRIDE_SCHEDULES GOS,
2908: pa_tasks TASK
2909: where GOS.award_id = p_award_id
2910: and GOS.project_id = p_project_id
2911: and p_item_task_id = TASK.task_id
2912: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2939: from pa_tasks

2935: begin
2936: l_test := 0;
2937: select 1
2938: into l_test
2939: from pa_tasks
2940: where task_id = p_item_task_id
2941: and top_task_id = p_task_id;
2942: exception
2943: when no_data_found then