APPS.IGIRX_IMP_IAC_REP dependencies on FA_DEPRN_PERIODS

Line 445: fa_deprn_periods dp

441: sob.Currency_Code
442: FROM fa_system_controls sc,
443: gl_sets_of_books sob,
444: fa_book_controls bc,
445: fa_deprn_periods dp
446: WHERE
447: bc.Book_Type_Code = p_book_type_code AND
448: sob.Set_Of_Books_ID = bc.Set_Of_Books_ID AND
449: dp.book_type_code =bc.Book_Type_Code AND

Line 461: FROM fa_deprn_periods

457:
458: CURSOR C_period (p_max_period_counter in VARCHAR2)
459: IS
460: SELECT period_name
461: FROM fa_deprn_periods
462: WHERE Book_Type_Code = p_book_type_code AND
463: period_counter = p_max_period_counter-1;
464:
465: CURSOR C_counter(p_distribution_id in NUMBER

Line 470: FROM fa_deprn_periods dp,

466: ,p_fiscal_year in NUMBER
467: ,p_dist_source_book in VARCHAR2)
468: IS
469: SELECT dp.period_counter
470: FROM fa_deprn_periods dp,
471: fa_distribution_history dh
472: WHERE dh.date_ineffective between dp.period_open_date and dp.period_close_date AND
473: dp.book_type_code=p_book_type_code AND
474: dp.fiscal_year=p_fiscal_year AND

Line 525: fa_deprn_periods dp

521: dh.code_combination_id,
522: dh.date_ineffective,
523: dh.location_id
524: FROM fa_distribution_history dh,
525: fa_deprn_periods dp
526: WHERE dh.asset_id= p_asset_id AND
527: dh.book_type_code=p_dist_source_book AND
528: (nvl(dh.date_ineffective,dp.period_open_date)>=dp.period_open_date) AND
529: dp.Book_type_code=p_book_type_code AND

Line 532: FROM fa_deprn_periods

528: (nvl(dh.date_ineffective,dp.period_open_date)>=dp.period_open_date) AND
529: dp.Book_type_code=p_book_type_code AND
530: dp.fiscal_year=p_fiscal_year AND
531: dp.period_num=(SELECT min(period_num)
532: FROM fa_deprn_periods
533: WHERE fiscal_year=p_fiscal_year AND
534: book_type_code=p_book_type_code);
535:
536: CURSOR C_asset(p_category_id in number)

Line 592: FROM fa_deprn_summary ds, fa_deprn_periods dp

588:
589: CURSOR C_ytd_asset_non_dep(p_asset_id in number, p_book_type_code in varchar2)
590: IS
591: SELECT ytd_deprn,fiscal_year
592: FROM fa_deprn_summary ds, fa_deprn_periods dp
593: WHERE ds.asset_id=p_asset_id AND
594: ds.book_type_code=p_book_type_code AND
595: ds.book_type_code = dp.book_type_code and
596: ds.period_counter= (select max(period_counter)

Line 682: l_curr_fiscal_year fa_deprn_periods.fiscal_year%type;

678: l_login_id NUMBER;
679: l_user_id NUMBER;
680: l_path_name VARCHAR2(150);
681: l_deprn_flag fa_books.depreciate_flag%type;
682: l_curr_fiscal_year fa_deprn_periods.fiscal_year%type;
683: l_asset_fiscal_year fa_deprn_periods.fiscal_year%type;
684: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
685: l_YTD_prorate_dists_idx binary_integer;
686: idx_YTD binary_integer;

Line 683: l_asset_fiscal_year fa_deprn_periods.fiscal_year%type;

679: l_user_id NUMBER;
680: l_path_name VARCHAR2(150);
681: l_deprn_flag fa_books.depreciate_flag%type;
682: l_curr_fiscal_year fa_deprn_periods.fiscal_year%type;
683: l_asset_fiscal_year fa_deprn_periods.fiscal_year%type;
684: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
685: l_YTD_prorate_dists_idx binary_integer;
686: idx_YTD binary_integer;
687: l_ytd_prorate_factor NUMBER;