APPS.GMS_EXP_ADJUSTMENT_PKG dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 249: -- found in ADL table then this encumbrance item is deleted from gms_encumbrance_items_all

245: -- ===================================================================================================
246: -- This cursor verifies whether any duplicate records are there in gms_award_distributions table
247: -- before copying the items by comparing the exp_type,task_id and quantity of origional and new items.
248: -- This is done as there is no link between the new and origional item. If a duplicate record is
249: -- found in ADL table then this encumbrance item is deleted from gms_encumbrance_items_all
250: -- table otherwise adl is created .
251: -- ===================================================================================================
252: CURSOR NEW_ITEMS (x_new_group VARCHAR2 ) IS
253: select e1.encumbrance_item_id,

Line 263: from gms_encumbrance_items_all e1

259: e1.created_by ,
260: e1.last_update_date ,
261: e1.last_updated_by ,
262: e1.last_update_login
263: from gms_encumbrance_items_all e1
264: ,gms_encumbrances_all e2
265:
266: where e2.encumbrance_group = x_new_group
267: and e2.encumbrance_id = e1.encumbrance_id

Line 289: from gms_encumbrance_items_all e1

285: e1.created_by ,
286: e1.last_update_date ,
287: e1.last_updated_by ,
288: e1.last_update_login
289: from gms_encumbrance_items_all e1
290: ,gms_encumbrances_all e2
291: ,gms_encumbrance_groups_all e3
292: where e3.encumbrance_group = x_org_group
293: and e3.encumbrance_group = e2.encumbrance_group

Line 401: from gms_encumbrance_items_all e1

397: e1.last_updated_by ,
398: e1.last_update_login ,
399: e1.adjusted_encumbrance_item_id
400:
401: from gms_encumbrance_items_all e1
402: ,gms_encumbrances_all e2
403:
404: where e2.encumbrance_group = x_new_group
405: and e2.encumbrance_id = e1.encumbrance_id;