APPS.FA_SORP_REVALUATION_PKG dependencies on FA_DEPRN_SUMMARY

Line 97: from fa_deprn_summary

93: group by PERIOD_COUNTER_CREATED;
94:
95: CURSOR c_get_reval_expenses(c_period_counter_impaired number) is
96: select sum(REVAL_DEPRN_EXPENSE),count(*)
97: from fa_deprn_summary
98: where asset_id = p_asset_id and
99: PERIOD_COUNTER >= c_period_counter_impaired
100: and book_type_code=p_book_type_code;
101: l_c_get_old_fin_rec c_get_old_fin_rec%rowtype;

Line 517: FROM fa_deprn_summary deprn_sum,

513: 2
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

Line 606: FROM fa_deprn_summary deprn_sum,

602: 2
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

Line 630: FROM fa_deprn_summary deprn_sum,

626: / imp.net_book_value
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

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