APPS.FA_MASSCP_PKG dependencies on FA_ASSET_FAILURES_GT

Line 87: fa_asset_failures_gt af

83: fpw.corp_transaction_header_id,
84: fpw.tax_transaction_header_id,
85: af.asset_id same_asset_id_fail
86: from fa_parallel_workers fpw,
87: fa_asset_failures_gt af
88: where fpw.request_id = p_parent_request_id
89: and fpw.process_status = 'UNASSIGNED'
90: and fpw.worker_number = p_request_number
91: and fpw.process_order = p_process_order

Line 399: insert into fa_asset_failures_gt (asset_id)

395:
396: -- since it's possible the same asset could be picked up in multiple
397: -- loops, we are using minus here to insure we don't raise ora-1
398:
399: insert into fa_asset_failures_gt (asset_id)
400: select distinct column_value
401: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx
402: minus
403: select asset_id

Line 404: from fa_asset_failures_gt;

400: select distinct column_value
401: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx
402: minus
403: select asset_id
404: from fa_asset_failures_gt;
405:
406: if (g_log_level_rec.statement_level) then
407: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count,
408: p_log_level_rec => g_log_level_rec);