APPS.PA_PROJ_TSK_UTILS dependencies on PA_EI_DENORM

Line 121: -- 3. Added reference to pa_ei_denorm for

117: -- clause is required for task deletion
118: -- 2. Removed join to PA_TASKS in cursor c3
119: -- as task_id is a not null column in
120: -- pa_expenditures_all
121: -- 3. Added reference to pa_ei_denorm for
122: -- checking if expenditures exist
123: --
124: -- 01-JAN-97 T. Saifee Modified
125: -- Condition project id = null incorporated into the task id = null

Line 142: FROM pa_ei_denorm e

138: FROM pa_expenditure_items_all i
139: WHERE i.project_id = x_project_id)
140: OR EXISTS
141: (SELECT NULL
142: FROM pa_ei_denorm e
143: WHERE e.project_id = x_project_id);
144:
145: cursor c2 is
146: SELECT 1

Line 156: FROM PA_EI_DENORM

152: FROM PA_TASKS
153: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
154: START WITH TASK_ID = x_TASK_ID))
155: or exists (SELECT NULL
156: FROM PA_EI_DENORM
157: WHERE TASK_ID IN
158: (SELECT TASK_ID
159: FROM PA_TASKS
160: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 169: FROM PA_EI_DENORM

165: where exists (SELECT NULL
166: FROM PA_EXPENDITURE_ITEMS_all
167: WHERE TASK_ID = x_TASK_ID)
168: or exists (SELECT NULL
169: FROM PA_EI_DENORM
170: WHERE TASK_ID = x_TASK_ID);
171:
172: /* cursor c2 is
173: SELECT 1