DBA Data[Home] [Help]

APPS.GL_RECURRING_BATCHES_PKG dependencies on GL_AUTO_ALLOC_BATCHES

Line 710: FROM GL_RECURRING_BATCHES rb, GL_AUTO_ALLOC_BATCHES aab

706:
707: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
708: CURSOR chk_autoalloc_set is
709: SELECT 'Batch used in AutoAlloc set'
710: FROM GL_RECURRING_BATCHES rb, GL_AUTO_ALLOC_BATCHES aab
711: WHERE rb.rowid = X_Rowid
712: AND aab.batch_id = rb.recurring_batch_id;
713: dummy VARCHAR2(100);
714: BEGIN

Line 737: FROM GL_AUTO_ALLOC_BATCHES aab

733:
734: PROCEDURE check_batch(X_Recurring_Batch_Id NUMBER) IS
735: CURSOR chk_autoalloc_set IS
736: SELECT 'Batch used in AutoAlloc set'
737: FROM GL_AUTO_ALLOC_BATCHES aab
738: WHERE aab.batch_id = X_Recurring_Batch_Id;
739: dummy VARCHAR2(100);
740: BEGIN
741: -- Make sure that this recurring batch is not being used by any