APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on FA_DEPRN_SUMMARY

Line 7655: l_fxh_rec.source_table := G_FA_DEPRN_SUMMARY;

7651: -- initialize the local l_fxlv_rec to the input record values
7652: l_fxh_rec.khr_id := l_khr_id;
7653: l_fxh_rec.try_id := NULL; -- Not sure what to be stamped here
7654: l_fxh_rec.source_id := p_deprn_run_id; -- For time being stamping the Deprn Run ID
7655: l_fxh_rec.source_table := G_FA_DEPRN_SUMMARY;
7656:
7657: -- get the representation details based on book_type_code. MG uptake
7658: OPEN get_reps_csr(p_book_type_code);
7659: FETCH get_reps_csr INTO l_ledger_id, l_fxh_rec.representation_code,

Line 7793: l_fxl_rec.source_table := G_FA_DEPRN_SUMMARY;

7789: --l_fxll_tbl := l_null_fxll_tbl;
7790: -- Assign the Mandatory Fields first like header_extension_id, fa_transaction_id [Deprn Run Id]
7791: -- kle_id, Asset ID, Source ID and Source ID.
7792: l_fxl_rec.source_id := p_deprn_run_id; -- For time bing stamping the Deprn Run ID
7793: l_fxl_rec.source_table := G_FA_DEPRN_SUMMARY;
7794: l_fxl_rec.header_extension_id := l_header_extension_id;
7795: l_fxl_rec.fa_transaction_id := p_deprn_run_id;
7796: l_fxl_rec.kle_id := l_deprn_asset_tbl(i).kle_id;
7797: l_fxl_rec.asset_id := l_deprn_asset_tbl(i).asset_id;

Line 7961: FROM fa_deprn_summary fa_dep

7957: SELECT fa_dep.deprn_run_id deprn_run_id
7958: ,ast.dnz_chr_id khr_id
7959: ,ast.cle_id kle_id
7960: ,fa_dep.asset_id asset_id
7961: FROM fa_deprn_summary fa_dep
7962: ,okc_k_items okc_item
7963: ,okc_k_lines_b ast
7964: ,okl_parallel_processes opp
7965: WHERE fa_dep.book_type_code = p_book_type_code

Line 7992: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'

7988: )
7989: IS
7990: SELECT MAX(fa_transaction_id) max_deprn_run_id
7991: FROM okl_ext_fa_line_sources_b fxl
7992: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'
7993: AND fxl.asset_book_type_code = p_asset_book_type_code
7994: AND fxl.period_counter = p_period_counter
7995: ; -- End of Cursor get_max_deprn_run_id
7996:

Line 8260: FROM fa_deprn_summary fa_dep

8256: IS
8257: SELECT chr.id khr_id
8258: ,chr.contract_number contract_number
8259: ,COUNT(fa_dep.asset_id) no_of_assets
8260: FROM fa_deprn_summary fa_dep
8261: ,fa_books fa_books
8262: ,okc_k_headers_all_b chr
8263: WHERE -- Predicates on fa_deprn_summary
8264: fa_dep.book_type_code = p_book_type_code

Line 8263: WHERE -- Predicates on fa_deprn_summary

8259: ,COUNT(fa_dep.asset_id) no_of_assets
8260: FROM fa_deprn_summary fa_dep
8261: ,fa_books fa_books
8262: ,okc_k_headers_all_b chr
8263: WHERE -- Predicates on fa_deprn_summary
8264: fa_dep.book_type_code = p_book_type_code
8265: AND fa_dep.period_counter = p_period_counter
8266: AND fa_dep.deprn_source_code = 'DEPRN'
8267: AND fa_dep.deprn_run_id IS NOT NULL

Line 8274: -- Join Conditions between fa_deprn_summary and fa_books

8270: -- Predicates on fa_books
8271: AND fa_books.transaction_header_id_out IS NULL
8272: AND fa_books.date_ineffective IS NULL
8273: AND fa_books.contract_id IS NOT NULL
8274: -- Join Conditions between fa_deprn_summary and fa_books
8275: AND fa_dep.asset_id = fa_books.asset_id
8276: AND fa_dep.book_type_code = fa_books.book_type_code
8277: -- Join conditions between fa_books and okc_k_headers_all_b
8278: AND fa_books.contract_id = chr.id

Line 8290: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'

8286: )
8287: IS
8288: SELECT MAX(fa_transaction_id) max_deprn_run_id
8289: FROM okl_ext_fa_line_sources_b fxl
8290: WHERE fxl.source_table = 'FA_DEPRN_SUMMARY'
8291: AND fxl.asset_book_type_code = p_asset_book_type_code
8292: AND fxl.period_counter = p_period_counter
8293: ; -- End of Cursor get_max_deprn_run_id
8294: