782: dh.distribution_id,
783: dh.code_combination_id,
784: dh.date_ineffective
785: FROM
786: fa_distribution_history dh,
787: fa_deprn_periods dp
788: WHERE
789: dh.asset_id= p_asset_id AND
790: dh.book_type_code=p_book_type_code AND
806: ,p_fiscal_year in NUMBER)
807: IS
808: SELECT dp.period_counter
809: FROM fa_deprn_periods dp,
810: fa_distribution_history dh
811: WHERE (dh.date_ineffective between dp.period_open_date and dp.period_close_date) AND
812: dp.book_type_code=p_book_type_code AND
813: dp.fiscal_year=p_fiscal_year AND
814: dh.book_type_code=p_book_type_code AND
847:
848: CURSOR C_active_dists
849: IS
850: SELECT count(*)
851: FROM fa_distribution_history
852: WHERE book_type_code=p_book_type_code AND
853: asset_id=p_asset_id AND
854: date_ineffective IS NULL;
855:
1645: ||drec.distribution_id );
1646:
1647: SELECT units_assigned
1648: INTO l_units
1649: FROM fa_distribution_history
1650: WHERE distribution_id = drec.distribution_id ;
1651:
1652: IF l_units =0
1653: THEN