DBA Data[Home] [Help]

APPS.GL_RECURRING_BATCHES_PKG dependencies on GL_AUTO_ALLOC_BATCHES

Line 706: FROM GL_RECURRING_BATCHES rb, GL_AUTO_ALLOC_BATCHES aab

702:
703: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
704: CURSOR chk_autoalloc_set is
705: SELECT 'Batch used in AutoAlloc set'
706: FROM GL_RECURRING_BATCHES rb, GL_AUTO_ALLOC_BATCHES aab
707: WHERE rb.rowid = X_Rowid
708: AND aab.batch_id = rb.recurring_batch_id
709: AND aab.batch_type_code = 'R';--added this condition for bug13324816
710: dummy VARCHAR2(100);

Line 734: FROM GL_AUTO_ALLOC_BATCHES aab

730:
731: PROCEDURE check_batch(X_Recurring_Batch_Id NUMBER) IS
732: CURSOR chk_autoalloc_set IS
733: SELECT 'Batch used in AutoAlloc set'
734: FROM GL_AUTO_ALLOC_BATCHES aab
735: WHERE aab.batch_id = X_Recurring_Batch_Id
736: AND aab.batch_type_code = 'R';--added this condition for bug13324816
737: dummy VARCHAR2(100);
738: BEGIN