APPS.FA_TRANS_API_PUB dependencies on FA_BOOK_CONTROLS

Line 376: from fa_book_controls

372: -- Derive set of books id for primary book
373: if (l_asset_hdr_rec.set_of_books_id is NULL) then
374: select set_of_books_id
375: into l_asset_hdr_rec.set_of_books_id
376: from fa_book_controls
377: where book_type_code = l_asset_hdr_rec.book_type_code;
378: end if;
379:
380: -- ***** Asset Descriptive Info ***** --

Line 1033: from fa_book_controls

1029: -- Derive set of books id for primary book
1030: if (l_asset_hdr_rec.set_of_books_id is NULL) then
1031: select set_of_books_id
1032: into l_asset_hdr_rec.set_of_books_id
1033: from fa_book_controls
1034: where book_type_code = l_asset_hdr_rec.book_type_code;
1035: end if;
1036:
1037: -- Get the old asset financial record

Line 1527: from fa_book_controls

1523: -- Derive set of books id for primary book
1524: if (l_asset_hdr_rec.set_of_books_id is NULL) then
1525: select set_of_books_id
1526: into l_asset_hdr_rec.set_of_books_id
1527: from fa_book_controls
1528: where book_type_code = l_asset_hdr_rec.book_type_code;
1529: end if;
1530:
1531: -- ***** Asset Distribution Info ***** --

Line 1689: from fa_book_controls

1685: -- Derive set of books id for primary book
1686: if (l_asset_hdr_rec.set_of_books_id is NULL) then
1687: select set_of_books_id
1688: into l_asset_hdr_rec.set_of_books_id
1689: from fa_book_controls
1690: where book_type_code = l_asset_hdr_rec.book_type_code;
1691: end if;
1692:
1693: -- ***** Asset Distribution Info ***** --

Line 1844: from fa_book_controls

1840: -- Derive set of books id for primary book
1841: if (l_src_asset_hdr_rec.set_of_books_id is NULL) then
1842: select set_of_books_id
1843: into l_src_asset_hdr_rec.set_of_books_id
1844: from fa_book_controls
1845: where book_type_code = l_src_asset_hdr_rec.book_type_code;
1846: end if;
1847:
1848: -- ***** Destination Asset Transaction Info ***** --

Line 2144: from fa_book_controls

2140:
2141: -- Derive set of books id for primary book
2142: /* select set_of_books_id
2143: into l_asset_hdr_rec.set_of_books_id
2144: from fa_book_controls
2145: where book_type_code = l_asset_hdr_rec.book_type_code;
2146: */
2147: -- ***** Asset Category Info ***** --
2148: l_asset_cat_rec_new.category_id := p_new_category_id;

Line 2419: from fa_book_controls

2415: -- Derive set of books id for primary book
2416: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2417: select set_of_books_id
2418: into l_asset_hdr_rec.set_of_books_id
2419: from fa_book_controls
2420: where book_type_code = l_asset_hdr_rec.book_type_code;
2421: end if;
2422:
2423: -- ***** Asset Retirement Info ***** --

Line 2689: from fa_book_controls

2685: -- Derive set of books id for primary book
2686: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2687: select set_of_books_id
2688: into l_asset_hdr_rec.set_of_books_id
2689: from fa_book_controls
2690: where book_type_code = l_asset_hdr_rec.book_type_code;
2691: end if;
2692:
2693: -- ***** Asset Retirement Info ***** --

Line 2894: from fa_book_controls

2890: -- Derive set of books id for primary book
2891: if (l_asset_hdr_rec.set_of_books_id is NULL) then
2892: select set_of_books_id
2893: into l_asset_hdr_rec.set_of_books_id
2894: from fa_book_controls
2895: where book_type_code = l_asset_hdr_rec.book_type_code;
2896: end if;
2897:
2898: -- ***** Asset Retirement Info ***** --

Line 3151: from fa_book_controls

3147: -- Derive set of books id for primary book
3148: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3149: select set_of_books_id
3150: into l_asset_hdr_rec.set_of_books_id
3151: from fa_book_controls
3152: where book_type_code = l_asset_hdr_rec.book_type_code;
3153: end if;
3154:
3155: -- ***** Asset Retirement Info ***** --

Line 3324: from fa_book_controls

3320: -- Derive set of books id for primary book
3321: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3322: select set_of_books_id
3323: into l_asset_hdr_rec.set_of_books_id
3324: from fa_book_controls
3325: where book_type_code = l_asset_hdr_rec.book_type_code;
3326: end if;
3327:
3328: -- ***** Asset Financial Info ***** --

Line 3471: from fa_book_controls

3467: -- Derive set of books id for primary book
3468: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3469: select set_of_books_id
3470: into l_asset_hdr_rec.set_of_books_id
3471: from fa_book_controls
3472: where book_type_code = l_asset_hdr_rec.book_type_code;
3473: end if;
3474:
3475: -- ***** Asset Financial Info ***** --

Line 3687: from fa_book_controls

3683:
3684: --@@@ Derive set of books id for primary book
3685: /* select set_of_books_id
3686: into l_asset_hdr_rec.set_of_books_id
3687: from fa_book_controls
3688: where book_type_code = l_asset_hdr_rec.book_type_code;
3689: */
3690:
3691: -- ***** Asset Descriptive Info ***** --

Line 3938: from fa_book_controls

3934: -- Derive set of books id for primary book
3935: if (l_asset_hdr_rec.set_of_books_id is NULL) then
3936: select set_of_books_id
3937: into l_asset_hdr_rec.set_of_books_id
3938: from fa_book_controls
3939: where book_type_code = l_asset_hdr_rec.book_type_code;
3940: end if;
3941:
3942: -- ***** Invoice Info ***** --

Line 4173: from fa_book_controls

4169: -- Derive set of books id for primary book
4170: if (l_asset_hdr_rec.set_of_books_id is NULL) then
4171: select set_of_books_id
4172: into l_asset_hdr_rec.set_of_books_id
4173: from fa_book_controls
4174: where book_type_code = l_asset_hdr_rec.book_type_code;
4175: end if;
4176:
4177: -- ***** Asset Retirement Info ***** --

Line 4371: from fa_book_controls

4367: -- Derive set of books id for primary book
4368: if (l_asset_hdr_rec.set_of_books_id is NULL) then
4369: select set_of_books_id
4370: into l_asset_hdr_rec.set_of_books_id
4371: from fa_book_controls
4372: where book_type_code = l_asset_hdr_rec.book_type_code;
4373: end if;
4374:
4375: -- ***** Unplanned Depreciation Info ***** --