748: o.representation_code,
749: o.representation_name,
750: o.representation_type
751: FROM okl_representations_v o,
752: fa_book_controls f
753: WHERE o.ledger_id = f.set_of_books_id
754: AND f.book_type_name = p_book_type_name;
755:
756: -- get the representations based on book_type_code .. MG uptake
759: o.representation_code,
760: o.representation_name,
761: o.representation_type
762: FROM okl_representations_v o,
763: fa_book_controls f
764: WHERE o.ledger_id = f.set_of_books_id
765: AND f.book_type_code = p_book_type_code;
766:
767: -- get the reporting product based on the contract product .. MG uptake
772:
773: -- get the book_type_name for asset book type code .. MG uptake
774: CURSOR get_book_type_name(p_book_type_code varchar2) IS
775: SELECT book_type_name
776: FROM fa_book_controls
777: WHERE book_type_code = p_book_type_code;
778:
779: PROCEDURE write_to_log(
780: p_level IN VARCHAR2,