APPS.JL_ZZ_FA_LIBRARY_1_PKG dependencies on FA_BOOKS

Line 53: PROCEDURE get_fa_books (asset_id IN NUMBER,

49: WHEN OTHERS THEN
50: Errcd := SQLCODE;
51: END get_check_inflation_adjustment;
52:
53: PROCEDURE get_fa_books (asset_id IN NUMBER,
54: attr_category IN VARCHAR2,
55: book_type IN VARCHAR2,
56: current_reval IN OUT VARCHAR2,
57: previous_reval IN OUT VARCHAR2,

Line 75: FROM fa_books

71: previous_reval,
72: last_appr_no,
73: last_appr_date,
74: last_appr_value
75: FROM fa_books
76: WHERE asset_id = TO_CHAR (asset_id)
77: AND date_ineffective IS NULL
78: AND global_attribute_category = attr_category
79: AND book_type_code = book_type

Line 84: END get_fa_books;

80: AND rownum = row_number;
81: EXCEPTION
82: WHEN OTHERS THEN
83: Errcd := SQLCODE;
84: END get_fa_books;
85:
86:
87: END JL_ZZ_FA_LIBRARY_1_PKG;