APPS.FA_TRANS_API_PUB dependencies on FA_BOOK_CONTROLS

Line 359: from fa_book_controls

355: -- Derive set of books id for primary book
356: if (l_asset_hdr_rec.set_of_books_id is NULL) then
357: select set_of_books_id
358: into l_asset_hdr_rec.set_of_books_id
359: from fa_book_controls
360: where book_type_code = l_asset_hdr_rec.book_type_code;
361: end if;
362:
363: -- ***** Asset Descriptive Info ***** --

Line 981: from fa_book_controls

977: -- Derive set of books id for primary book
978: if (l_asset_hdr_rec.set_of_books_id is NULL) then
979: select set_of_books_id
980: into l_asset_hdr_rec.set_of_books_id
981: from fa_book_controls
982: where book_type_code = l_asset_hdr_rec.book_type_code;
983: end if;
984:
985: -- Get the old asset financial record

Line 1447: from fa_book_controls

1443: -- Derive set of books id for primary book
1444: if (l_asset_hdr_rec.set_of_books_id is NULL) then
1445: select set_of_books_id
1446: into l_asset_hdr_rec.set_of_books_id
1447: from fa_book_controls
1448: where book_type_code = l_asset_hdr_rec.book_type_code;
1449: end if;
1450:
1451: -- ***** Asset Distribution Info ***** --

Line 1608: from fa_book_controls

1604: -- Derive set of books id for primary book
1605: if (l_asset_hdr_rec.set_of_books_id is NULL) then
1606: select set_of_books_id
1607: into l_asset_hdr_rec.set_of_books_id
1608: from fa_book_controls
1609: where book_type_code = l_asset_hdr_rec.book_type_code;
1610: end if;
1611:
1612: -- ***** Asset Distribution Info ***** --

Line 1762: from fa_book_controls

1758: -- Derive set of books id for primary book
1759: if (l_src_asset_hdr_rec.set_of_books_id is NULL) then
1760: select set_of_books_id
1761: into l_src_asset_hdr_rec.set_of_books_id
1762: from fa_book_controls
1763: where book_type_code = l_src_asset_hdr_rec.book_type_code;
1764: end if;
1765:
1766: -- ***** Destination Asset Transaction Info ***** --

Line 2061: from fa_book_controls

2057:
2058: -- Derive set of books id for primary book
2059: /* select set_of_books_id
2060: into l_asset_hdr_rec.set_of_books_id
2061: from fa_book_controls
2062: where book_type_code = l_asset_hdr_rec.book_type_code;
2063: */
2064: -- ***** Asset Category Info ***** --
2065: l_asset_cat_rec_new.category_id := p_new_category_id;

Line 2335: from fa_book_controls

2331: -- Derive set of books id for primary book
2332: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2333: select set_of_books_id
2334: into l_asset_hdr_rec.set_of_books_id
2335: from fa_book_controls
2336: where book_type_code = l_asset_hdr_rec.book_type_code;
2337: end if;
2338:
2339: -- ***** Asset Retirement Info ***** --

Line 2604: from fa_book_controls

2600: -- Derive set of books id for primary book
2601: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2602: select set_of_books_id
2603: into l_asset_hdr_rec.set_of_books_id
2604: from fa_book_controls
2605: where book_type_code = l_asset_hdr_rec.book_type_code;
2606: end if;
2607:
2608: -- ***** Asset Retirement Info ***** --

Line 2808: from fa_book_controls

2804: -- Derive set of books id for primary book
2805: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2806: select set_of_books_id
2807: into l_asset_hdr_rec.set_of_books_id
2808: from fa_book_controls
2809: where book_type_code = l_asset_hdr_rec.book_type_code;
2810: end if;
2811:
2812: -- ***** Asset Retirement Info ***** --

Line 3064: from fa_book_controls

3060: -- Derive set of books id for primary book
3061: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3062: select set_of_books_id
3063: into l_asset_hdr_rec.set_of_books_id
3064: from fa_book_controls
3065: where book_type_code = l_asset_hdr_rec.book_type_code;
3066: end if;
3067:
3068: -- ***** Asset Retirement Info ***** --

Line 3236: from fa_book_controls

3232: -- Derive set of books id for primary book
3233: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3234: select set_of_books_id
3235: into l_asset_hdr_rec.set_of_books_id
3236: from fa_book_controls
3237: where book_type_code = l_asset_hdr_rec.book_type_code;
3238: end if;
3239:
3240: -- ***** Asset Financial Info ***** --

Line 3382: from fa_book_controls

3378: -- Derive set of books id for primary book
3379: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3380: select set_of_books_id
3381: into l_asset_hdr_rec.set_of_books_id
3382: from fa_book_controls
3383: where book_type_code = l_asset_hdr_rec.book_type_code;
3384: end if;
3385:
3386: -- ***** Asset Financial Info ***** --

Line 3596: from fa_book_controls

3592:
3593: --@@@ Derive set of books id for primary book
3594: /* select set_of_books_id
3595: into l_asset_hdr_rec.set_of_books_id
3596: from fa_book_controls
3597: where book_type_code = l_asset_hdr_rec.book_type_code;
3598: */
3599:
3600: -- ***** Asset Descriptive Info ***** --

Line 3845: from fa_book_controls

3841: -- Derive set of books id for primary book
3842: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3843: select set_of_books_id
3844: into l_asset_hdr_rec.set_of_books_id
3845: from fa_book_controls
3846: where book_type_code = l_asset_hdr_rec.book_type_code;
3847: end if;
3848:
3849: -- ***** Invoice Info ***** --

Line 4078: from fa_book_controls

4074: -- Derive set of books id for primary book
4075: if (l_asset_hdr_rec.set_of_books_id is NULL) then
4076: select set_of_books_id
4077: into l_asset_hdr_rec.set_of_books_id
4078: from fa_book_controls
4079: where book_type_code = l_asset_hdr_rec.book_type_code;
4080: end if;
4081:
4082: -- ***** Asset Retirement Info ***** --

Line 4274: from fa_book_controls

4270: -- Derive set of books id for primary book
4271: if (l_asset_hdr_rec.set_of_books_id is NULL) then
4272: select set_of_books_id
4273: into l_asset_hdr_rec.set_of_books_id
4274: from fa_book_controls
4275: where book_type_code = l_asset_hdr_rec.book_type_code;
4276: end if;
4277:
4278: -- ***** Unplanned Depreciation Info ***** --