APPS.PA_PROJ_TSK_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 138: FROM pa_expenditure_items_all i

134: cursor c1 is
135: SELECT 1
136: FROM sys.dual
137: WHERE EXISTS (SELECT NULL
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

Line 149: FROM PA_EXPENDITURE_ITEMS_all

145: cursor c2 is
146: SELECT 1
147: FROM sys.dual
148: where exists (SELECT NULL
149: FROM PA_EXPENDITURE_ITEMS_all
150: WHERE TASK_ID IN
151: (SELECT TASK_ID
152: FROM PA_TASKS
153: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 166: FROM PA_EXPENDITURE_ITEMS_all

162: cursor c3 is
163: SELECT 1
164: FROM sys.dual
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);

Line 176: FROM PA_EXPENDITURE_ITEMS_all

172: /* cursor c2 is
173: SELECT 1
174: FROM sys.dual
175: where exists (SELECT NULL
176: FROM PA_EXPENDITURE_ITEMS_all
177: WHERE TASK_ID IN
178: (SELECT TASK_ID
179: FROM PA_TASKS
180: WHERE TASK_ID = x_TASK_ID));

Line 186: FROM PA_EXPENDITURE_ITEMS_all

182: cursor c3 is
183: SELECT 1
184: FROM sys.dual
185: where exists (SELECT NULL
186: FROM PA_EXPENDITURE_ITEMS_all
187: WHERE TASK_ID IN
188: (SELECT TASK_ID
189: FROM PA_TASKS
190: WHERE TASK_ID = x_TASK_ID));

Line 835: FROM PA_EXPENDITURE_ITEMS_all PAI,

831: cursor c1 is
832: select 1
833: from sys.dual
834: where exists (SELECT NULL
835: FROM PA_EXPENDITURE_ITEMS_all PAI,
836: PA_COST_DISTRIBUTION_LINES_all PCD
837: WHERE PAI.PROJECT_ID = x_PROJECT_ID
838: AND PAI.EXPENDITURE_ITEM_ID = PCD.EXPENDITURE_ITEM_ID); -- Bug 3461664
839:

Line 845: FROM PA_EXPENDITURE_ITEMS_all PAI,

841: cursor c2 is
842: select 1
843: from sys.dual
844: where exists (SELECT NULL
845: FROM PA_EXPENDITURE_ITEMS_all PAI,
846: PA_COST_DISTRIBUTION_LINES_all PCD
847: WHERE PAI.EXPENDITURE_ITEM_ID
848: = PCD.EXPENDITURE_ITEM_ID
849: AND PAI.TASK_ID = x_TASK_ID);