APPS.IGI_IAC_COMMON_UTILS dependencies on FA_DEPRN_PERIODS

Line 31: FROM fa_deprn_periods dp

27: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
28: dp.calendar_period_close_date , p_period_counter, dp.fiscal_year
29: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
30: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
31: FROM fa_deprn_periods dp
32: WHERE dp.book_type_code = P_book_type_code
33: AND dp.period_counter = P_period_counter ;
34:
35: EXCEPTION

Line 82: FROM fa_deprn_periods dp

78: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
79: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
80: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
81: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
82: FROM fa_deprn_periods dp
83: WHERE dp.book_type_code = P_book_type_code
84: AND P_date between dp.calendar_period_open_Date and dp.calendar_period_close_date;
85: EXCEPTION
86: WHEN NO_DATA_FOUND THEN

Line 130: FROM fa_deprn_periods dp

126: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
127: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
128: INTO p_prd_rec.period_num, p_prd_rec.period_name, p_prd_rec.period_start_date,
129: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
130: FROM fa_deprn_periods dp
131: WHERE dp.book_type_code = P_book_type_code
132: AND dp.period_name = P_prd_name ;
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN

Line 175: FROM fa_deprn_periods dp

171: SELECT dp.Period_Name, dp.Period_Counter, dp.Period_Num,
172: dp.Fiscal_Year, dp.calendar_Period_open_Date, dp.calendar_Period_close_Date
173: INTO p_prd_rec.Period_Name, p_prd_rec.Period_Counter, p_prd_rec.Period_Num,
174: p_prd_rec.Fiscal_Year, p_prd_rec.Period_Start_Date, p_prd_rec.Period_End_Date
175: FROM fa_deprn_periods dp
176: WHERE dp.book_type_code = P_book_type_code
177: AND dp.period_close_date IS NULL ;
178:
179: RETURN TRUE;

Line 524: FROM fa_deprn_periods dp

520: BEGIN
521: l_path_name := g_path||'is_asset_rvl_in_curr_period';
522: SELECT dp.period_counter
523: INTO l_curr_prd_Counter
524: FROM fa_deprn_periods dp
525: WHERE dp.book_type_Code = P_book_type_code
526: AND dp.period_close_date IS NULL;
527:
528: l_prev_prd_counter := l_curr_prd_Counter - 1;

Line 566: fa_deprn_periods dp

562:
563: SELECT count(*)
564: INTO l_tot_records
565: FROM fa_transaction_headers ft ,
566: fa_deprn_periods dp
567: WHERE ft.book_type_Code = P_book_type_code
568: AND ft.asset_id = P_asset_id
569: AND dp.book_type_Code = P_book_type_code
570: AND dp.period_close_Date IS NULL

Line 794: FROM fa_deprn_periods dp

790: SELECT dp.period_num, dp.period_name, dp.calendar_period_open_date ,
791: dp.calendar_period_close_date , dp.period_counter, dp.fiscal_year
792: INTO l_prd_rec.period_num, l_prd_rec.period_name, l_prd_rec.period_start_date,
793: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
794: FROM fa_deprn_periods dp
795: WHERE dp.book_type_code = X_book_type_code
796: AND l_dpis between dp.calendar_period_open_Date and dp.calendar_period_close_date;
797: EXCEPTION
798: WHEN NO_DATA_FOUND THEN