APPS.FA_FIN_ADD_PKG dependencies on FA_BOOKS

Line 44: if (bks_calling_fn = 'fa_books_val.dpis_val' or

40:
41: x_return_status := true;
42: exception
43: when others then
44: if (bks_calling_fn = 'fa_books_val.dpis_val' or
45: bks_calling_fn = 'fa_books_val3.conv_code_val') then
46: -- called from forms validation module
47: FA_STANDARD_PKG.RAISE_ERROR(
48: CALLED_FN => 'fa_fin_add_pkg.get_deprn_start_date',

Line 45: bks_calling_fn = 'fa_books_val3.conv_code_val') then

41: x_return_status := true;
42: exception
43: when others then
44: if (bks_calling_fn = 'fa_books_val.dpis_val' or
45: bks_calling_fn = 'fa_books_val3.conv_code_val') then
46: -- called from forms validation module
47: FA_STANDARD_PKG.RAISE_ERROR(
48: CALLED_FN => 'fa_fin_add_pkg.get_deprn_start_date',
49: CALLING_FN => Bks_Calling_Fn,

Line 104: FROM fa_category_book_defaults cbd, fa_books bks

100: -- requirement not to null out the default group asset for a category when
101: -- a group is disabled. However, we can't assign an asset to a disabled group. */
102: SELECT count(1)
103: INTO l_grp_count
104: FROM fa_category_book_defaults cbd, fa_books bks
105: WHERE cbd.category_id = X_Category_Id
106: AND cbd.book_type_code = X_BOOK_TYPE_CODE
107: AND cbd.book_type_code = bks.book_type_code
108: AND cbd.group_asset_id = bks.asset_id

Line 125: from fa_books

121: -- syoung: performance tuning: count(*) to count(1)
122: -- and inserted rownum condition.
123: select count(1)
124: into lv_count
125: from fa_books
126: where asset_id = X_ASSET_ID
127: and book_type_code = X_BOOK_TYPE_CODE
128: and date_ineffective is null
129: and rownum < 2;

Line 140: from fa_books bk, fa_book_controls bc

136: -- syoung: performance tuning: count(*) to count(1)
137: -- and inserted rownum condition.
138: select count(1)
139: into lv_count
140: from fa_books bk, fa_book_controls bc
141: where bk.asset_id= X_ASSET_ID
142: and bk.book_type_code <> X_BOOK_TYPE_CODE
143: and bk.date_ineffective is null
144: and bk.book_type_code = bc.book_type_code