DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on DUAL

Line 567: -- do the following only when called standalone for an individual trx

563: return false;
564: end if;
565:
566: -- BUG# 2247404 / BUG# 2230178
567: -- do the following only when called standalone for an individual trx
568: -- or for a mass transaction at main entry from that process
569: --
570: -- do not do it for each transaction called from a mass process
571: -- this will allow mass transactions like FAMAPT after a deprn run

Line 1376: -- For individual asset transaction only lock the active FA_BOOKS row

1372: end if;
1373:
1374: -- ******************************************************************
1375: -- Lock Book Controls row only if a Mass Request is submitted.
1376: -- For individual asset transaction only lock the active FA_BOOKS row
1377: -- For ADDITION not necessary to lock row. ADDITION should be allowed
1378: -- as long as depreciation or no mass request is running on the book
1379: -- Fix for Bug 1067205 - snarayan
1380: -- ******************************************************************

Line 1654: from dual

1650:
1651: -- Fix for Bug #6528245. Still need check member assets for group.
1652: select count(*)
1653: into h_count
1654: from dual
1655: where exists
1656: (select 'x'
1657: FROM fa_deprn_summary ds,
1658: fa_book_controls bc,