APPS.IGI_IAC_REVAL_UTILITIES dependencies on FA_CALENDAR_TYPES

Line 102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk

98: begin
99: l_path_name := g_path||'last_period_counter';
100: select ct.calendar_type , ct.number_per_fiscal_year , bk.life_in_months
101: into l_calendar_type , l_number_per_fiscal_year , l_life_in_months
102: from fa_calendar_types ct , fa_book_controls bc , fa_books bk
103: where ct.calendar_type = bc.deprn_calendar
104: and bk.book_type_code = p_book_type_code
105: and bk.date_ineffective is null
106: and bk.asset_id = p_asset_id

Line 138: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

134: FROM fa_book_controls
135: WHERE book_type_code like p_book_type_code;
136:
137: /* Bug 2763328 sekhar */
138: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
139: SELECT number_per_fiscal_year
140: FROM fa_calendar_types
141: WHERE calendar_type = p_calendar_type;
142:

Line 140: FROM fa_calendar_types

136:
137: /* Bug 2763328 sekhar */
138: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
139: SELECT number_per_fiscal_year
140: FROM fa_calendar_types
141: WHERE calendar_type = p_calendar_type;
142:
143: l_dpis_prd_rec IGI_IAC_TYPES.prd_rec;
144: l_curr_prd_rec IGI_IAC_TYPES.prd_rec;

Line 151: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

147: l_num_of_periods_in_cyr number;
148: l_last_period_counter number;
149: l_num_of_periods_total number;
150: fp_hist_info_old IGI_IAC_TYPES.fa_hist_asset_info;
151: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
152: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
153: l_path_name VARCHAR2(150);
154:
155: begin

Line 152: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

148: l_last_period_counter number;
149: l_num_of_periods_total number;
150: fp_hist_info_old IGI_IAC_TYPES.fa_hist_asset_info;
151: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
152: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
153: l_path_name VARCHAR2(150);
154:
155: begin
156: l_path_name := g_path||'populate_depreciation';

Line 674: FROM fa_calendar_types ct, fa_book_controls bc

670: AND fds.deprn_source_code = 'DEPRN';
671:
672: CURSOR c_get_periods_in_year IS
673: SELECT ct.number_per_fiscal_year
674: FROM fa_calendar_types ct, fa_book_controls bc
675: WHERE ct.calendar_type = bc.deprn_calendar
676: AND bc.book_type_code = fp_book_type_code;
677:
678: l_prorate_dists_idx binary_integer ;

Line 691: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;

687: l_dist_last_period NUMBER;
688: l_dist_active_periods NUMBER;
689: l_fully_reserved_counter NUMBER;
690: l_fully_reserved_period igi_iac_types.prd_rec;
691: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
692: l_total_periods NUMBER;
693: l_last_period igi_iac_types.prd_rec;
694: l_asset_prorate_units NUMBER;
695: l_life_in_months NUMBER;

Line 892: FROM fa_calendar_types ct, fa_book_controls bc

888: AND fds.deprn_source_code = 'DEPRN';
889:
890: CURSOR c_get_periods_in_year IS
891: SELECT ct.number_per_fiscal_year
892: FROM fa_calendar_types ct, fa_book_controls bc
893: WHERE ct.calendar_type = bc.deprn_calendar
894: AND bc.book_type_code = fp_book_type_code;
895:
896: l_prorate_dists_idx binary_integer ;

Line 909: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;

905: l_dist_last_period NUMBER;
906: l_dist_active_periods NUMBER;
907: l_fully_reserved_counter NUMBER;
908: l_fully_reserved_period igi_iac_types.prd_rec;
909: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
910: l_total_periods NUMBER;
911: l_last_period igi_iac_types.prd_rec;
912: l_asset_prorate_units NUMBER;
913: l_life_in_months NUMBER;