APPS.GMS_PA_API3 dependencies on PA_TASKS

Line 2477: FROM pa_tasks task

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

Line 2500: FROM pa_tasks task

2496: AND trunc(encumbrance_item_date) between trunc(p_start_date) and
2497: trunc(nvl(p_end_date, encumbrance_item_date))
2498: AND EXISTS
2499: (SELECT task_id
2500: FROM pa_tasks task
2501: WHERE task.task_id = ei.task_id
2502: AND task.cost_ind_sch_fixed_date IS NULL)
2503: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2504: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'

Line 2637: pa_tasks TASK

2633: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2634: /* calling new function item_task_validate */
2635: /* AND 1 = decode(p_task_id, NULL ,decode (1, (select 1
2636: from GMS_OVERRIDE_SCHEDULES GOS,
2637: pa_tasks TASK
2638: where GOS.award_id = p_award_id
2639: and GOS.project_id = p_project_id
2640: and nvl(ITEM.task_id,-99) = TASK.task_id
2641: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2645: from pa_tasks

2641: and nvl(GOS.task_id,-99) = TASK.top_task_id
2642: and rownum = 1) ,2
2643: ,1)
2644: ,decode((select top_task_id
2645: from pa_tasks
2646: where task_id = ITEM.task_id), p_task_id ,1
2647: ,2))*/
2648: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2649: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

Line 2697: pa_tasks TASK

2693: AND ITEM.ind_compiled_set_id is not null
2694: AND NOT EXISTS
2695: ( select 1
2696: from GMS_OVERRIDE_SCHEDULES GOS,
2697: pa_tasks TASK
2698: where GOS.award_id = p_award_id
2699: and GOS.project_id = ITEM.project_id
2700: and ITEM.task_id = TASK.task_id
2701: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id);

Line 2733: pa_tasks TASK

2729: if p_task id is not null, check if p_task_id = top_task_id for the enc. */
2730: /* calling new function item_task_validate */
2731: /* AND 1 = decode(p_task_id, NULL ,decode (1, (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 = p_project_id
2736: and nvl(ITEM.task_id,-99) = TASK.task_id
2737: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2741: from pa_tasks

2737: and nvl(GOS.task_id,-99) = TASK.top_task_id
2738: and rownum = 1) ,2
2739: ,1)
2740: ,decode((select top_task_id
2741: from pa_tasks
2742: where task_id = ITEM.task_id), p_task_id ,1
2743: ,2))*/
2744: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2745: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

Line 2788: pa_tasks TASK

2784: AND ITEM.ind_compiled_set_id is not null
2785: AND NOT EXISTS
2786: ( select 1
2787: from GMS_OVERRIDE_SCHEDULES GOS,
2788: pa_tasks TASK
2789: where GOS.award_id = p_award_id
2790: and GOS.project_id = ITEM.project_id
2791: and ITEM.task_id = TASK.task_id
2792: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id)

Line 2858: pa_tasks TASK

2854: l_test := 0;
2855: select 1
2856: into l_test
2857: from GMS_OVERRIDE_SCHEDULES GOS,
2858: pa_tasks TASK
2859: where GOS.award_id = p_award_id
2860: and GOS.project_id = p_project_id
2861: and p_item_task_id = TASK.task_id
2862: and nvl(GOS.task_id,-99) = TASK.top_task_id

Line 2889: from pa_tasks

2885: begin
2886: l_test := 0;
2887: select 1
2888: into l_test
2889: from pa_tasks
2890: where task_id = p_item_task_id
2891: and top_task_id = p_task_id;
2892: exception
2893: when no_data_found then