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 469: from fa_books bk1,fa_books bk2, fa_books bk3

465: /* Find cost for all three books, don't process asset if not same */
466:
467: select bk1.cost, bk2.cost, bk3.cost, nvl(bk1.adjusted_recoverable_cost, bk1.recoverable_cost)
468: into l_adj_cost, l_ctl_cost, l_corp_cost, l_adj_rec_cost
469: from fa_books bk1,fa_books bk2, fa_books bk3
470: where bk1.book_type_code = g_adj_asset_hdr_rec.book_type_code and
471: bk1.asset_id = g_adj_asset_hdr_rec.asset_id and
472: bk1.date_ineffective is null
473: and bk2.book_type_code = g_ctl_asset_hdr_rec.book_type_code and

Line 1025: l_book_type_code FA_BOOKS.book_type_code%type;

1021: l_end_number NUMBER;
1022: l_count NUMBER := 0;
1023:
1024: l_batch_size number;
1025: l_book_type_code FA_BOOKS.book_type_code%type;
1026: l_calling_fn varchar2(60) := 'fa_mass_dpr_rsv_adj_pkg.load_jobs';
1027:
1028: error_found exception;
1029: BEGIN

Line 1070: FROM FA_books

1066: SELECT NVL(max(asset_id), 0),
1067: nvl(min(asset_id), 1)
1068: INTO l_max_number,
1069: l_start_number
1070: FROM FA_books
1071: WHERE book_type_code = p_book_type_code
1072: AND transaction_header_id_out is null;
1073:
1074: WHILE (l_start_number <= l_max_number) LOOP

Line 1098: FROM FA_BOOKS BK

1094: 'UNASSIGNED', p_parent_request_id
1095: FROM ( SELECT /*+ parallel(BK) */
1096: ASSET_ID, FLOOR(RANK()
1097: OVER (ORDER BY ASSET_ID)/l_batch_size ) UNIT_ID
1098: FROM FA_BOOKS BK
1099: WHERE BK.BOOK_TYPE_CODE = p_book_type_code
1100: AND BK.TRANSACTION_HEADER_ID_OUT IS NULL )
1101: GROUP BY UNIT_ID;
1102: