APPS.GMS_BUDG_CONT_SETUP dependencies on PA_TASKS

Line 81: FROM pa_tasks pt2

77:
78: DELETE from gms_budgetary_controls bc
79: WHERE EXISTS
80: ( SELECT pt2.task_id
81: FROM pa_tasks pt2
82: WHERE bc.task_id=pt2.parent_task_id
83: AND ((p_entry_level_code = 'L') OR
84: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1
85: where bc.task_id = pt1.task_id

Line 84: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1

80: ( SELECT pt2.task_id
81: FROM pa_tasks pt2
82: WHERE bc.task_id=pt2.parent_task_id
83: AND ((p_entry_level_code = 'L') OR
84: (p_entry_level_code = 'M' AND exists (select 1 from pa_tasks pt1
85: where bc.task_id = pt1.task_id
86: and pt1.parent_task_id IS NOT NULL))))
87: AND bc.project_id = p_project_id
88: AND bc.award_id = p_award_id;

Line 118: FROM pa_tasks pt1

114: cursor c_tasks_no_bc is
115: SELECT
116: pt1.task_id,
117: pt1.top_task_id
118: FROM pa_tasks pt1
119: WHERE pt1.project_id = x_project_id
120: AND
121: ( (x_entry_level_code IN ( 'T' ,'M') AND pt1.parent_task_id is null )
122: OR

Line 127: FROM pa_tasks pt2

123: (x_entry_level_code IN ('L','M')
124: AND NOT EXISTS
125: ( SELECT
126: pt2.task_id
127: FROM pa_tasks pt2
128: WHERE pt1.task_id=pt2.parent_task_id)
129: )
130: )
131: AND not exists

Line 180: FROM pa_tasks pt1

176: cursor c_tasks_for_new_resource is
177: SELECT
178: pt1.task_id,
179: pt1.top_task_id
180: FROM pa_tasks pt1
181: WHERE pt1.project_id = x_project_id
182: AND
183: ( (x_entry_level_code IN ( 'T' ,'M') AND pt1.parent_task_id is null )
184: OR

Line 189: FROM pa_tasks pt2

185: (x_entry_level_code IN ('L','M')
186: AND NOT EXISTS
187: ( SELECT
188: pt2.task_id
189: FROM pa_tasks pt2
190: WHERE pt1.task_id=pt2.parent_task_id)
191: )
192: )
193: AND exists