APPS.FA_MASS_DPR_RSV_ADJ_PKG dependencies on FA_BOOKS

Line 106: FA_BOOKS BK,

102: AD.ASSET_TYPE,
103: AD.ASSET_CATEGORY_ID,
104: AD.CURRENT_UNITS */ --vmarella .
105: FROM FA_DEPRN_SUMMARY DS,
106: FA_BOOKS BK,
107: FA_ADDITIONS AD,
108: FA_TRANSACTION_HEADERS TH
109: WHERE DS.BOOK_TYPE_CODE = g_adj_asset_hdr_rec.book_type_code
110: AND DS.ASSET_ID = AD.ASSET_ID

Line 476: from fa_books bk1,fa_books bk2, fa_books bk3

472: /* Find cost for all three books, don't process asset if not same */
473:
474: select bk1.cost, bk2.cost, bk3.cost, nvl(bk1.adjusted_recoverable_cost, bk1.recoverable_cost)
475: into l_adj_cost, l_ctl_cost, l_corp_cost, l_adj_rec_cost
476: from fa_books bk1,fa_books bk2, fa_books bk3
477: where bk1.book_type_code = g_adj_asset_hdr_rec.book_type_code and
478: bk1.asset_id = g_adj_asset_hdr_rec.asset_id and
479: bk1.date_ineffective is null
480: and bk2.book_type_code = g_ctl_asset_hdr_rec.book_type_code and

Line 1037: l_book_type_code FA_BOOKS.book_type_code%type;

1033: l_end_number NUMBER;
1034: l_count NUMBER := 0;
1035:
1036: l_batch_size number;
1037: l_book_type_code FA_BOOKS.book_type_code%type;
1038: l_calling_fn varchar2(60) := 'fa_mass_dpr_rsv_adj_pkg.load_jobs';
1039:
1040: error_found exception;
1041: BEGIN

Line 1082: FROM FA_books

1078: SELECT NVL(max(asset_id), 0),
1079: nvl(min(asset_id), 1)
1080: INTO l_max_number,
1081: l_start_number
1082: FROM FA_books
1083: WHERE book_type_code = p_book_type_code
1084: AND transaction_header_id_out is null;
1085:
1086: WHILE (l_start_number <= l_max_number) LOOP

Line 1110: FROM FA_BOOKS BK

1106: 'UNASSIGNED', p_parent_request_id
1107: FROM ( SELECT /*+ parallel(BK) */
1108: ASSET_ID, FLOOR(RANK()
1109: OVER (ORDER BY ASSET_ID)/l_batch_size ) UNIT_ID
1110: FROM FA_BOOKS BK
1111: WHERE BK.BOOK_TYPE_CODE = p_book_type_code
1112: AND BK.TRANSACTION_HEADER_ID_OUT IS NULL )
1113: GROUP BY UNIT_ID;
1114: