DBA Data[Home] [Help]

APPS.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 284: (SELECT NULL FROM gms_encumbrance_items_all gei

280:
281: OR EXISTS
282: /* OR (l_gms_installed = 'Y' and EXISTS*/ /* for bug 6334295 */
283: /* (SELECT NULL FROM gms_encumbrance_items gei */ /* for bug 6334295 */
284: (SELECT NULL FROM gms_encumbrance_items_all gei
285: WHERE gei.ind_compiled_set_id = l_ind_compile_set_id
286: );
287:
288: /* Code added for Bug 6312921 :- ends */

Line 510: exists (SELECT NULL FROM gms_encumbrance_items_all gei

506: /* Bug6081362 */
507: cursor c4 is
508: select 1 from dual where exists (select 1 from pa_ind_compiled_sets ICS
509: WHERE ics.ind_rate_sch_revision_id =x_ind_rate_sch_revision_id and
510: exists (SELECT NULL FROM gms_encumbrance_items_all gei
511: WHERE ICS.ind_compiled_set_id = gei.ind_compiled_set_id
512: and ENCUMBRANCE_ITEM_DATE > x_end_date_active
513: /* and l_gms_installed = 'Y'*/ /* commented for bug 6334295 */
514: ));