APPS.FA_MASSCP_PKG dependencies on FA_ASSET_FAILURES_GT

Line 94: fa_asset_failures_gt af

90: fpw.corp_transaction_header_id,
91: fpw.tax_transaction_header_id,
92: af.asset_id same_asset_id_fail
93: from fa_parallel_workers fpw,
94: fa_asset_failures_gt af
95: where fpw.request_id = p_parent_request_id
96: and fpw.process_status = 'UNASSIGNED'
97: and fpw.worker_number = p_request_number
98: and fpw.process_order = p_process_order

Line 634: insert into fa_asset_failures_gt (asset_id)

630:
631: -- since it's possible the same asset could be picked up in multiple
632: -- loops, we are using minus here to insure we don't raise ora-1
633:
634: insert into fa_asset_failures_gt (asset_id)
635: select distinct column_value
636: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx
637: minus
638: select asset_id

Line 639: from fa_asset_failures_gt;

635: select distinct column_value
636: from TABLE(CAST(fa_asset_id_fail_tab AS fa_num15_tbl_type)) trx
637: minus
638: select asset_id
639: from fa_asset_failures_gt;
640:
641: if (g_log_level_rec.statement_level) then
642: fa_debug_pkg.add(l_calling_fn, 'rows inserted into fa_asset_failures', g_asset_error1_tbl.count, p_log_level_rec => g_log_level_rec);
643: end if;