APPS.CN_NOTIFY_AIA_OM dependencies on CN_COMM_LINES_API_ALL

Line 198: FROM cn_comm_lines_api_all

194: ( SELECT source_trx_line_id
195: FROM cn_not_trx_all
196: WHERE batch_id = p_batch_id and org_id = x_org_id and source_trx_line_id not in
197: (SELECT source_trx_line_id
198: FROM cn_comm_lines_api_all
199: WHERE process_batch_id = p_batch_id and org_id = x_org_id)
200: ) AND TRUNC(processed_date) BETWEEN p_start_date AND p_end_date;
201:
202: type fl_trx_Ord_tbl_type IS TABLE OF get_failed_trx_cr % rowtype INDEX BY pls_integer;