APPS.FA_CDE_PKG dependencies on FA_BOOK_CONTROLS

Line 43: -- Get fa_book_controls.distribution_source_book since

39: NOWAIT;
40:
41: begin <>
42:
43: -- Get fa_book_controls.distribution_source_book since
44: -- production is only stored in the corporate book.
45:
46: -- fazcbc cache should have already been called don't call again -bmr
47:

Line 453: fa_book_controls bc,

449: h_dpis,
450: h_deprn_start_date
451: from fa_books bk,
452: fa_fiscal_year fy,
453: fa_book_controls bc,
454: fa_book_controls bc2
455: where bc.book_type_code = X_Book_Type_Code
456: and fy.fiscal_year_name = bc.fiscal_year_name
457: and fy.fiscal_year = X_Fiscal_Year

Line 454: fa_book_controls bc2

450: h_deprn_start_date
451: from fa_books bk,
452: fa_fiscal_year fy,
453: fa_book_controls bc,
454: fa_book_controls bc2
455: where bc.book_type_code = X_Book_Type_Code
456: and fy.fiscal_year_name = bc.fiscal_year_name
457: and fy.fiscal_year = X_Fiscal_Year
458: and bc2.book_type_code = X_Book_Type_Code

Line 471: fa_book_controls bc

467: X_Conversion_Date is not NULL) then
468: select count(*)
469: into h_conversion_year
470: from fa_fiscal_year fy,
471: fa_book_controls bc
472: where bc.book_type_code = X_Book_Type_Code
473: and bc.fiscal_year_name = fy.fiscal_year_name
474: and X_Conversion_Date between fy.start_date and
475: fy.end_date;

Line 1076: fa_book_controls

1072: which retirement prorate date
1073: falls into
1074:
1075: nbv_frac_thresh nbv_frac_thresh nbv_fraction_threshhold in
1076: fa_book_controls
1077:
1078: nbv_amt_thresh nbv_amt_thresh nbv_amount_threshhold in
1079: fa_book_controls
1080:

Line 1079: fa_book_controls

1075: nbv_frac_thresh nbv_frac_thresh nbv_fraction_threshhold in
1076: fa_book_controls
1077:
1078: nbv_amt_thresh nbv_amt_thresh nbv_amount_threshhold in
1079: fa_book_controls
1080:
1081: projecting_flag deprn_projecting_flag
1082:
1083:

Line 1085: fa_book_controls

1081: projecting_flag deprn_projecting_flag
1082:
1083:
1084: amo_reval_rsv_flag amo_reval_rsv_flag amortize_reval_reserve_flag in
1085: fa_book_controls
1086:
1087: raf rate_adj_factor rate_adjustment_factor in fa_books
1088:
1089: cur_fy cur_fy current fiscal year

Line 1295: fa_book_controls fbc

1291: cursor c_prd_flag is
1292: select 'Y'
1293: from fa_calendar_periods fcp1,
1294: fa_calendar_periods fcp2,
1295: fa_book_controls fbc
1296: where to_date (dpr_in.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1297: and fbc.book_type_code = dpr_in.book
1298: and fcp1.calendar_type = fbc.deprn_calendar
1299: and to_date (decode( dpr_in.jdate_retired,0,null,dpr_in.jdate_retired),'J') BETWEEN fcp2.start_date and fcp2.end_date

Line 1469: -- Get the following information from the FA_BOOK_CONTROLS cache

1465:
1466: deprn_projecting_flag := (fmode = fa_std_types.FA_DPR_PROJECT);
1467:
1468: --
1469: -- Get the following information from the FA_BOOK_CONTROLS cache
1470: -- 1. Rate Calendar
1471: -- 2. NBV Fraction Threshold
1472: -- 3. NBV Amount Threshold
1473: -- 4. Amortize Reval Reserve Flag

Line 4250: from fa_book_controls bc, fa_calendar_types ct

4246: -- Get calendar Info: type, fy_name and num_per_fiscal_year
4247: /* SELECT bc.deprn_calendar, bc.fiscal_year_name,
4248: ct.number_per_fiscal_year
4249: into h_calendar_type, h_fy_name, h_num_per_fy
4250: from fa_book_controls bc, fa_calendar_types ct
4251: where bc.book_type_code = book
4252: and bc.deprn_calendar = ct.calendar_type;
4253: */
4254: h_calendar_type:= fa_cache_pkg.fazcbc_record.deprn_calendar;