APPS.IGI_IAC_COMMON_UTILS dependencies on FA_DEPRN_PERIODS

Line 54: FROM fa_deprn_periods dp

50: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
51: dp.calendar_period_close_date , p_period_counter, dp.fiscal_year
52: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
53: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
54: FROM fa_deprn_periods dp
55: WHERE dp.book_type_code = P_book_type_code
56: AND dp.period_counter = P_period_counter ;
57:
58: EXCEPTION

Line 105: FROM fa_deprn_periods dp

101: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
102: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
103: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
104: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
105: FROM fa_deprn_periods dp
106: WHERE dp.book_type_code = P_book_type_code
107: AND P_date between dp.calendar_period_open_Date and dp.calendar_period_close_date;
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN

Line 153: FROM fa_deprn_periods dp

149: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
150: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
151: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
152: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
153: FROM fa_deprn_periods dp
154: WHERE dp.book_type_code = P_book_type_code
155: AND dp.period_name = P_prd_name ;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 198: FROM fa_deprn_periods dp

194: SELECT dp.Period_Name, dp.Period_Counter, dp.Period_Num,
195: dp.Fiscal_Year, dp.calendar_Period_open_Date, dp.calendar_Period_close_Date
196: INTO p_prd_rec.Period_Name, p_prd_rec.Period_Counter, p_prd_rec.Period_Num,
197: p_prd_rec.Fiscal_Year, p_prd_rec.Period_Start_Date, p_prd_rec.Period_End_Date
198: FROM fa_deprn_periods dp
199: WHERE dp.book_type_code = P_book_type_code
200: AND dp.period_close_date IS NULL ;
201:
202: RETURN TRUE;

Line 554: FROM fa_deprn_periods dp

550: BEGIN
551: l_path_name := g_path||'is_asset_rvl_in_curr_period';
552: SELECT dp.period_counter
553: INTO l_curr_prd_Counter
554: FROM fa_deprn_periods dp
555: WHERE dp.book_type_Code = P_book_type_code
556: AND dp.period_close_date IS NULL;
557:
558: l_prev_prd_counter := l_curr_prd_Counter - 1;

Line 596: fa_deprn_periods dp

592:
593: SELECT count(*)
594: INTO l_tot_records
595: FROM fa_transaction_headers ft ,
596: fa_deprn_periods dp
597: WHERE ft.book_type_Code = P_book_type_code
598: AND ft.asset_id = P_asset_id
599: AND dp.book_type_Code = P_book_type_code
600: AND dp.period_close_Date IS NULL

Line 824: FROM fa_deprn_periods dp

820: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
821: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
822: INTO l_prd_rec.period_num, l_prd_rec.period_name, l_prd_rec.period_start_date,
823: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
824: FROM fa_deprn_periods dp
825: WHERE dp.book_type_code = X_book_type_code
826: AND l_dpis between dp.calendar_period_open_Date and dp.calendar_period_close_date;
827: EXCEPTION
828: WHEN NO_DATA_FOUND THEN