eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 168: -- from pa_expenditure_items ei

164: -- select 1
165: -- from pa_ind_compiled_sets ics
166: -- where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
167: -- and exists (select null
168: -- from pa_expenditure_items ei
169: -- where tp_ind_compiled_set_id = ics.ind_compiled_set_id);
170: -- cursor c1 is
171: -- select 1
172: -- from pa_ind_compiled_sets ics

Line 175: -- and exists (select /+ index(ei PA_EXPENDITURE_ITEMS_N11) / null --added hint for bug 5845101

171: -- select 1
172: -- from pa_ind_compiled_sets ics
173: -- where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
174: -- /*and not exists (select null -- Changed the not exists to exists */
175: -- and exists (select /*+ index(ei PA_EXPENDITURE_ITEMS_N11) */ null --added hint for bug 5845101
176: -- from pa_expenditure_items ei
177: -- where cost_ind_compiled_set_id = ics.ind_compiled_set_id);
178: --
179: -- cursor c2 is

Line 176: -- from pa_expenditure_items ei

172: -- from pa_ind_compiled_sets ics
173: -- where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
174: -- /*and not exists (select null -- Changed the not exists to exists */
175: -- and exists (select /*+ index(ei PA_EXPENDITURE_ITEMS_N11) */ null --added hint for bug 5845101
176: -- from pa_expenditure_items ei
177: -- where cost_ind_compiled_set_id = ics.ind_compiled_set_id);
178: --
179: -- cursor c2 is
180: -- select 1

Line 185: -- from pa_expenditure_items

181: -- from pa_ind_compiled_sets ics
182: -- where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
183: -- /*and not exists (select null -- Changed the not exists to exists */
184: -- and exists (select null
185: -- from pa_expenditure_items
186: -- where rev_ind_compiled_set_id = ics.ind_compiled_set_id);
187: --
188: -- cursor c3 is
189: -- select 1

Line 194: -- from pa_expenditure_items

190: -- from pa_ind_compiled_sets ics
191: --where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
192: -- /*and not exists (select null -- Changed the not exists to exists */
193: -- and exists (select null
194: -- from pa_expenditure_items
195: -- where inv_ind_compiled_set_id = ics.ind_compiled_set_id);
196: --
197: /* Commenting code for Bug 6312921 ends here */
198: /* Code added for Bug 6312921 :- starts */

Line 208: /* from pa_expenditure_items ei / / for bug 6334295 */

204: cursor c0 (l_ind_compile_set_id number) is
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

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 215: where exists (select /+ index(ei PA_EXPENDITURE_ITEMS_N11) / null --added hint for bug 5845101

211:
212: cursor c1 (l_ind_compile_set_id number) is
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:

Line 216: /* from pa_expenditure_items ei / / for bug 6334295 */

212: cursor c1 (l_ind_compile_set_id number) is
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

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 224: /* from pa_expenditure_items / / for bug 6334295 */

220: cursor c2 (l_ind_compile_set_id number ) is
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

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 232: /* from pa_expenditure_items / / for bug 6334295 */

228: cursor c3 (l_ind_compile_set_id number ) is
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 */

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 307: from pa_expenditure_items ei,

303: into x_dummy
304: from sys.dual
305: where not exists
306: (select 1
307: from pa_expenditure_items ei,
308: pa_ind_compiled_sets ics
309: where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
310: and ( (ei.cost_ind_compiled_set_id = ics.ind_compiled_set_id)
311: or (ei.rev_ind_compiled_set_id = ics.ind_compiled_set_id)

Line 475: from pa_expenditure_items ei

471: select 1
472: from pa_ind_compiled_sets ics
473: where ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
474: and exists (select null
475: from pa_expenditure_items ei
476: where tp_ind_compiled_set_id = ics.ind_compiled_set_id and expenditure_item_date > x_end_date_active);
477:
478:
479: cursor c1 is

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