APPS.FA_TRACK_MEMBER_PVT dependencies on FA_BOOK_CONTROLS

Line 123: from fa_book_controls

119: open GET_PERIOD_COUNTER;
120: fetch GET_PERIOD_COUNTER into h_period_counter;
121: if GET_PERIOD_COUNTER%NOTFOUND then
122: select deprn_calendar into h_deprn_calendar
123: from fa_book_controls
124: where book_type_code=P_Book_Type_code;
125: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar,
126: p_log_level_rec => p_log_level_rec) then
127: fa_srvr_msg.add_message (calling_fn => l_calling_fn,

Line 143: from fa_book_controls

139: open GET_PERIOD_COUNTER_MRC;
140: fetch GET_PERIOD_COUNTER_MRC into h_period_counter;
141: if GET_PERIOD_COUNTER_MRC%NOTFOUND then
142: select deprn_calendar into h_deprn_calendar
143: from fa_book_controls
144: where book_type_code=P_Book_Type_code;
145: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
146: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
147: p_log_level_rec => p_log_level_rec);

Line 4307: from fa_book_controls

4303: h_period_per_fiscal_year := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
4304:
4305: select fiscal_year_name, deprn_calendar
4306: into h_fiscal_year_name,h_calendar_type
4307: from fa_book_controls
4308: where book_type_code=h_book_type_code;
4309:
4310: select fiscal_year into h_trans_fiscal_year
4311: from fa_fiscal_year

Line 7146: from fa_book_controls

7142: h_start_period_counter := h_start_fiscal_year*h_period_per_fiscal_year+h_start_period_num;
7143:
7144: select fiscal_year_name, deprn_calendar
7145: into h_fiscal_year_name,h_calendar_type
7146: from fa_book_controls
7147: where book_type_code = h_book_type_code;
7148:
7149: if (p_log_level_rec.statement_level) then
7150: 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);

Line 8815: from fa_book_controls

8811:
8812: -- Query Group Asset DPIS' period counter and amort date's period counter from FA_BOOKS
8813: select deprn_calendar, fiscal_year_name
8814: into h_deprn_calendar, h_fiscal_year_name
8815: from fa_book_controls
8816: where book_type_code = h_book_type_code;
8817:
8818: if (p_log_level_rec.statement_level) then
8819: fa_debug_pkg.add(l_calling_fn, 'h_deprn_calendar:h_fiscal_year_name',