APPS.FA_SORP_REVALUATION_PKG dependencies on FA_DEPRN_PERIODS

Line 80: from fa_deprn_periods

76: and c_start_date between cp.start_date and cp.end_date;
77:
78: CURSOR c_get_open_period_rec IS
79: select period_num,fiscal_year,PERIOD_COUNTER
80: from fa_deprn_periods
81: where book_type_code = p_book_type_code
82: and PERIOD_CLOSE_DATE is null;
83:
84: Cursor c_get_deprn_rsv_out(c_period_counter_impaired number) is

Line 518: fa_deprn_periods deprn_periods,

514: )
515: )
516: ) deprn_delta
517: FROM fa_deprn_summary deprn_sum,
518: fa_deprn_periods deprn_periods,
519: fa_impairments imp,
520: fa_itf_impairments itf
521: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
522: AND deprn_sum.period_counter = deprn_periods.period_counter

Line 607: fa_deprn_periods deprn_periods,

603: )
604: )
605: ) deprn_delta
606: FROM fa_deprn_summary deprn_sum,
607: fa_deprn_periods deprn_periods,
608: fa_impairments imp,
609: fa_itf_impairments itf
610: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
611: AND deprn_sum.period_counter = deprn_periods.period_counter

Line 631: fa_deprn_periods deprn_periods,

627: ),
628: 2
629: ) deprn_delta
630: FROM fa_deprn_summary deprn_sum,
631: fa_deprn_periods deprn_periods,
632: fa_impairments imp,
633: fa_itf_impairments itf
634: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
635: AND deprn_sum.period_counter = deprn_periods.period_counter

Line 657: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods

653:
654: --Below query finds the number of deprn runs after the impairment
655: SELECT COUNT (1)
656: INTO v_deprn_cnt
657: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods
658: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
659: AND deprn_sum.period_counter = deprn_periods.period_counter
660: AND deprn_periods.period_close_date IS NOT NULL
661: AND deprn_sum.book_type_code = p_book_type_code

Line 724: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods

720:
721: --Below query finds the number of deprn runs after the impairment
722: SELECT COUNT (1)
723: INTO v_deprn_cnt
724: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods
725: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
726: AND deprn_sum.period_counter = deprn_periods.period_counter
727: AND deprn_periods.period_close_date IS NOT NULL
728: AND deprn_sum.book_type_code = p_book_type_code

Line 755: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods

751:
752: --Below query finds the number of deprn runs after the impairment
753: SELECT COUNT (1)
754: INTO v_deprn_cnt
755: FROM fa_deprn_summary deprn_sum, fa_deprn_periods deprn_periods
756: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
757: AND deprn_sum.period_counter = deprn_periods.period_counter
758: AND deprn_periods.period_close_date IS NOT NULL
759: AND deprn_sum.book_type_code = p_book_type_code

Line 2114: FROM FA_DEPRN_PERIODS

2110: AND adj.transaction_header_id > c_th_id;
2111:
2112: CURSOR c_get_imp_pc_a is
2113: SELECT period_counter
2114: FROM FA_DEPRN_PERIODS
2115: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2116: AND period_name in
2117: (SELECT fa_period
2118: FROM fa_sorp_asset_link_reval_v

Line 2125: FROM FA_DEPRN_PERIODS fdp,

2121: AND mass_reval_id = p_reval_options_rec.mass_reval_id);
2122:
2123: CURSOR c_get_imp_pc_c is
2124: SELECT period_counter
2125: FROM FA_DEPRN_PERIODS fdp,
2126: fa_sorp_asset_link_reval_v salrv
2127: WHERE fdp.book_type_code = p_asset_hdr_rec.book_type_code
2128: AND salrv.asset_id = p_asset_hdr_rec.asset_id
2129: AND salrv.book_type_code = p_asset_hdr_rec.book_type_code

Line 2360: from FA_DEPRN_PERIODS

2356: AND SET_OF_BOOKS_ID = p_set_of_books_id;
2357:
2358: cursor c_get_fiscal_name is
2359: Select fiscal_year,period_num
2360: from FA_DEPRN_PERIODS
2361: where book_type_code = p_asset_hdr_rec.book_type_code
2362: and period_counter = p_loss_pc;
2363:
2364: l_dpr_in FA_STD_TYPES.dpr_struct;