APPS.FA_AMORT_PVT dependencies on FA_CALENDAR_PERIODS

Line 75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy

71: l_calling_fn varchar2(40) := 'FA_AMORT_PVT.get_dcal_pc';
72: BEGIN
73: SELECT fcp.period_num +( fct.number_per_fiscal_year * ffy.fiscal_year)
74: INTO l_pc
75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy
76: WHERE pp_date BETWEEN fcp.start_date AND fcp.end_date
77: AND pp_date BETWEEN ffy.start_date AND ffy.end_date
78: AND fct.calendar_type = fcp.calendar_type
79: AND ffy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 188: from fa_calendar_periods

184:
185: CURSOR c_get_period_info IS
186: select start_date
187: , end_date
188: from fa_calendar_periods
189: where calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
190: and to_date (to_char (p_jdate), 'J') between start_date
191: and end_date;
192:

Line 362: , fa_calendar_periods cp

358: , 'N'
359: from fa_book_controls bc
360: , fa_fiscal_year fy
361: , fa_calendar_types ct
362: , fa_calendar_periods cp
363: where bc.book_type_code = p_asset_hdr_rec.book_type_code
364: and bc.deprn_calendar = ct.calendar_type
365: and bc.fiscal_year_name = fy.fiscal_year_name
366: and ct.fiscal_year_name = bc.fiscal_year_name

Line 1040: , fa_calendar_periods cp

1036: , fy.fiscal_year fiscal_year
1037: , 'N'
1038: from fa_fiscal_year fy
1039: , fa_calendar_types ct
1040: , fa_calendar_periods cp
1041: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1042: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1043: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1044: and ct.calendar_type = cp.calendar_type

Line 7673: from fa_calendar_periods cp,

7669: from fa_deprn_summary ds, fa_deprn_periods dp
7670: ,
7671: (select (fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
7672: add_amort_period
7673: from fa_calendar_periods cp,
7674: fa_book_controls bc,
7675: fa_fiscal_year fy,
7676: fa_calendar_types ct,
7677: fa_transaction_headers th

Line 11636: from fa_calendar_periods cp,

11632: -- this cursor will fetch the fiscal year
11633: -- for the prorate date.
11634: CURSOR c_get_dpis_period IS
11635: select fy.fiscal_year
11636: from fa_calendar_periods cp,
11637: fa_book_controls bc,
11638: fa_fiscal_year fy,
11639: fa_calendar_types ct,
11640: fa_books bk

Line 11951: fa_calendar_periods cp,

11947: '2nd SELECT in c_get_ths_adj'
11948: from fa_transaction_headers th,
11949: fa_retirements ret,
11950: fa_conventions con,
11951: fa_calendar_periods cp,
11952: fa_calendar_periods cptrx
11953: where th.asset_id = p_asset_hdr_rec.asset_id
11954: and th.book_type_code = p_asset_hdr_rec.book_type_code
11955: and ret.asset_id = p_asset_hdr_rec.asset_id

Line 11952: fa_calendar_periods cptrx

11948: from fa_transaction_headers th,
11949: fa_retirements ret,
11950: fa_conventions con,
11951: fa_calendar_periods cp,
11952: fa_calendar_periods cptrx
11953: where th.asset_id = p_asset_hdr_rec.asset_id
11954: and th.book_type_code = p_asset_hdr_rec.book_type_code
11955: and ret.asset_id = p_asset_hdr_rec.asset_id
11956: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 13214: from fa_calendar_periods cp,

13210:
13211: -- Get the prorate period counter for the retirement
13212: select fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
13213: into l_ret_prorate_pc
13214: from fa_calendar_periods cp,
13215: fa_book_controls bc,
13216: fa_fiscal_year fy,
13217: fa_calendar_types ct,
13218: fa_retirements ret,