APPS.FA_TRACK_MEMBER_PVT dependencies on FA_BOOK_CONTROLS

Line 148: from fa_book_controls

144: open GET_PERIOD_COUNTER;
145: fetch GET_PERIOD_COUNTER into h_period_counter;
146: if GET_PERIOD_COUNTER%NOTFOUND then
147: select deprn_calendar into h_deprn_calendar
148: from fa_book_controls
149: where book_type_code=P_Book_Type_code;
150: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
151: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
152: raise main_err;

Line 164: from fa_book_controls

160: open GET_PERIOD_COUNTER_MRC;
161: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;
162: if GET_PERIOD_COUNTER_MRC%NOTFOUND then
163: select deprn_calendar into h_deprn_calendar
164: from fa_book_controls
165: where book_type_code=P_Book_Type_code;
166: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
167: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
168: raise main_err;

Line 4463: from fa_book_controls

4459: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4460:
4461: select fiscal_year_name, deprn_calendar
4462: into h_fiscal_year_name,h_calendar_type
4463: from fa_book_controls
4464: where book_type_code=h_book_type_code;
4465:
4466: select fiscal_year into h_trans_fiscal_year
4467: from fa_fiscal_year

Line 7324: from fa_book_controls

7320: h_set_of_books_id := p_asset_hdr_rec.set_of_books_id;
7321:
7322: select fiscal_year_name, deprn_calendar
7323: into h_fiscal_year_name,h_calendar_type
7324: from fa_book_controls
7325: where book_type_code = h_book_type_code;
7326:
7327: if (p_log_level_rec.statement_level) then
7328: fa_debug_pkg.add(l_calling_fn, 'h_fiscal_year_name:h_calendar_type', h_fiscal_year_name||':'||h_calendar_type, p_log_level_rec => p_log_level_rec);

Line 9111: from fa_book_controls

9107:
9108: -- Query Group Asset DPIS' period counter and amort date's period counter from FA_BOOKS
9109: select deprn_calendar, fiscal_year_name
9110: into h_deprn_calendar, h_fiscal_year_name
9111: from fa_book_controls
9112: where book_type_code = h_book_type_code;
9113:
9114: if (p_log_level_rec.statement_level) then
9115: fa_debug_pkg.add(l_calling_fn, 'h_deprn_calendar:h_fiscal_year_name',