APPS.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 209: from pa_expenditure_items_all ei

205: select 1
206: from dual
207: where exists (select null
208: /* from pa_expenditure_items ei */ /* for bug 6334295 */
209: from pa_expenditure_items_all ei
210: where tp_ind_compiled_set_id = l_ind_compile_set_id );
211:
212: cursor c1 (l_ind_compile_set_id number) is
213: select 1

Line 217: from pa_expenditure_items_all ei

213: select 1
214: from dual
215: where exists (select /*+ index(ei PA_EXPENDITURE_ITEMS_N11) */ null --added hint for bug 5845101
216: /* from pa_expenditure_items ei */ /* for bug 6334295 */
217: from pa_expenditure_items_all ei
218: where cost_ind_compiled_set_id = l_ind_compile_set_id);
219:
220: cursor c2 (l_ind_compile_set_id number ) is
221: select 1

Line 225: from pa_expenditure_items_all

221: select 1
222: from dual
223: where exists (select null
224: /* from pa_expenditure_items */ /* for bug 6334295 */
225: from pa_expenditure_items_all
226: where rev_ind_compiled_set_id = l_ind_compile_set_id);
227:
228: cursor c3 (l_ind_compile_set_id number ) is
229: select 1

Line 233: from pa_expenditure_items_all

229: select 1
230: from dual
231: where exists (select null
232: /* from pa_expenditure_items */ /* for bug 6334295 */
233: from pa_expenditure_items_all
234: where inv_ind_compiled_set_id = l_ind_compile_set_id);
235:
236: /* Code added for Bug 6312921 :- ends */
237:

Line 485: from pa_expenditure_items_all ei

481: from pa_ind_compiled_sets ics
482: where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
483: /*and not exists (select null -- Changed the not exists to exists */
484: and exists (select null
485: from pa_expenditure_items_all ei
486: where cost_ind_compiled_set_id = ics.ind_compiled_set_id and expenditure_item_date > x_end_date_active);
487:
488: cursor c2 is
489: select 1

Line 494: from pa_expenditure_items_all

490: from pa_ind_compiled_sets ics
491: where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
492: /*and not exists (select null -- Changed the not exists to exists */
493: and exists (select null
494: from pa_expenditure_items_all
495: where rev_ind_compiled_set_id = ics.ind_compiled_set_id and expenditure_item_date > x_end_date_active);
496:
497: cursor c3 is
498: select 1

Line 503: from pa_expenditure_items_all

499: from pa_ind_compiled_sets ics
500: where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
501: /*and not exists (select null -- Changed the not exists to exists */
502: and exists (select null
503: from pa_expenditure_items_all
504: where inv_ind_compiled_set_id = ics.ind_compiled_set_id and expenditure_item_date > x_end_date_active);
505:
506: /* Bug6081362 */
507: cursor c4 is