DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on DUAL

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

546: return false;
547: end if;
548:
549: -- BUG# 2247404 / BUG# 2230178
550: -- do the following only when called standalone for an individual trx
551: -- or for a mass transaction at main entry from that process
552: --
553: -- do not do it for each transaction called from a mass process
554: -- this will allow mass transactions like FAMAPT after a deprn run

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

1331: end if;
1332:
1333: -- ******************************************************************
1334: -- Lock Book Controls row only if a Mass Request is submitted.
1335: -- For individual asset transaction only lock the active FA_BOOKS row
1336: -- For ADDITION not necessary to lock row. ADDITION should be allowed
1337: -- as long as depreciation or no mass request is running on the book
1338: -- Fix for Bug 1067205 - snarayan
1339: -- ******************************************************************

Line 1699: from dual

1695:
1696: -- Fix for Bug #6528245. Still need check member assets for group.
1697: select count(*)
1698: into h_count
1699: from dual
1700: where exists
1701: (select 'x'
1702: FROM fa_deprn_summary ds,
1703: fa_book_controls bc,