APPS.FA_TRACK_MEMBER_PVT dependencies on DUAL

Line 39: -- Main logic to track individual asset level amounts.

35: --
36: -- Function: track_assets
37: --
38: -- Description:
39: -- Main logic to track individual asset level amounts.
40: --
41: -- Returns:
42: -- 0 - No error / 1 - Error
43: --

Line 5606: from dual;

5602: if p_mrc_sob_type_code <> 'R' then
5603: -- Get new Transaction Header ID
5604: select fa_transaction_headers_s.nextval
5605: into p_transaction_header_id
5606: from dual;
5607:
5608: -- Bug 8703676 : Store the trx_hdr_id during the primary loop
5609: g_primary_trx_hdr_id_tbl(l_index) := p_transaction_header_id;
5610: l_index := l_index + 1;

Line 11403: from dual

11399: l_tbl_ytd_deprn(j) as ytd_deprn,
11400: l_tbl_bonus_deprn_reserve(j) as bonus_deprn_reserve,
11401: l_tbl_bonus_ytd_deprn(j) as bonus_ytd_deprn,
11402: l_tbl_eofy_reserve(j) as eofy_reserve
11403: from dual
11404: ) TM
11405: ON ((BS.ASSET_ID = tm.member_asset_id) AND
11406: (BS.BOOK_TYPE_CODE = p_book_type_code) AND
11407: (BS.SET_OF_BOOKS_ID = tm.set_of_books_id) AND

Line 11495: from dual

11491: l_tbl_ytd_deprn(j) as ytd_deprn,
11492: l_tbl_bonus_deprn_reserve(j) as bonus_deprn_reserve,
11493: l_tbl_bonus_ytd_deprn(j) as bonus_ytd_deprn,
11494: l_tbl_eofy_reserve(j) as eofy_reserve
11495: from dual
11496: ) TM
11497: ON ((BS.ASSET_ID = tm.member_asset_id) AND
11498: (BS.BOOK_TYPE_CODE = p_book_type_code) AND
11499: (BS.PERIOD_COUNTER = tm.period_counter))