APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on FA_DEPRN_SUMMARY

Line 7770: l_fxh_rec.source_table := G_FA_DEPRN_SUMMARY;

7766: -- initialize the local l_fxlv_rec to the input record values
7767: l_fxh_rec.khr_id := l_khr_id;
7768: l_fxh_rec.try_id := NULL; -- Not sure what to be stamped here
7769: l_fxh_rec.source_id := p_deprn_run_id; -- For time being stamping the Deprn Run ID
7770: l_fxh_rec.source_table := G_FA_DEPRN_SUMMARY;
7771:
7772: -- get the representation details based on book_type_code. MG uptake
7773: OPEN get_reps_csr(p_book_type_code);
7774: FETCH get_reps_csr INTO l_ledger_id, l_fxh_rec.representation_code,

Line 7908: l_fxl_rec.source_table := G_FA_DEPRN_SUMMARY;

7904: --l_fxll_tbl := l_null_fxll_tbl;
7905: -- Assign the Mandatory Fields first like header_extension_id, fa_transaction_id [Deprn Run Id]
7906: -- kle_id, Asset ID, Source ID and Source ID.
7907: l_fxl_rec.source_id := p_deprn_run_id; -- For time bing stamping the Deprn Run ID
7908: l_fxl_rec.source_table := G_FA_DEPRN_SUMMARY;
7909: l_fxl_rec.header_extension_id := l_header_extension_id;
7910: l_fxl_rec.fa_transaction_id := p_deprn_run_id;
7911: l_fxl_rec.kle_id := l_deprn_asset_tbl(i).kle_id;
7912: l_fxl_rec.asset_id := l_deprn_asset_tbl(i).asset_id;

Line 8076: FROM fa_deprn_summary fa_dep

8072: SELECT fa_dep.deprn_run_id deprn_run_id
8073: ,ast.dnz_chr_id khr_id
8074: ,ast.cle_id kle_id
8075: ,fa_dep.asset_id asset_id
8076: FROM fa_deprn_summary fa_dep
8077: ,okc_k_items okc_item
8078: ,okc_k_lines_b ast
8079: ,okl_parallel_processes opp
8080: WHERE fa_dep.book_type_code = p_book_type_code

Line 8107: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'

8103: )
8104: IS
8105: SELECT MAX(fa_transaction_id) max_deprn_run_id
8106: FROM okl_ext_fa_line_sources_b fxl
8107: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'
8108: AND fxl.asset_book_type_code = p_asset_book_type_code
8109: AND fxl.period_counter = p_period_counter
8110: ; -- End of Cursor get_max_deprn_run_id
8111:

Line 8375: FROM fa_deprn_summary fa_dep

8371: IS
8372: SELECT chr.id khr_id
8373: ,chr.contract_number contract_number
8374: ,COUNT(fa_dep.asset_id) no_of_assets
8375: FROM fa_deprn_summary fa_dep
8376: ,fa_books fa_books
8377: ,okc_k_headers_all_b chr
8378: WHERE -- Predicates on fa_deprn_summary
8379: fa_dep.book_type_code = p_book_type_code

Line 8378: WHERE -- Predicates on fa_deprn_summary

8374: ,COUNT(fa_dep.asset_id) no_of_assets
8375: FROM fa_deprn_summary fa_dep
8376: ,fa_books fa_books
8377: ,okc_k_headers_all_b chr
8378: WHERE -- Predicates on fa_deprn_summary
8379: fa_dep.book_type_code = p_book_type_code
8380: AND fa_dep.period_counter = p_period_counter
8381: AND fa_dep.deprn_source_code = 'DEPRN'
8382: AND fa_dep.deprn_run_id IS NOT NULL

Line 8389: -- Join Conditions between fa_deprn_summary and fa_books

8385: -- Predicates on fa_books
8386: AND fa_books.transaction_header_id_out IS NULL
8387: AND fa_books.date_ineffective IS NULL
8388: AND fa_books.contract_id IS NOT NULL
8389: -- Join Conditions between fa_deprn_summary and fa_books
8390: AND fa_dep.asset_id = fa_books.asset_id
8391: AND fa_dep.book_type_code = fa_books.book_type_code
8392: -- Join conditions between fa_books and okc_k_headers_all_b
8393: AND fa_books.contract_id = chr.id

Line 8405: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'

8401: )
8402: IS
8403: SELECT MAX(fa_transaction_id) max_deprn_run_id
8404: FROM okl_ext_fa_line_sources_b fxl
8405: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'
8406: AND fxl.asset_book_type_code = p_asset_book_type_code
8407: AND fxl.period_counter = p_period_counter
8408: ; -- End of Cursor get_max_deprn_run_id
8409: