2555:
2556: CURSOR get_tap_id_csr(p_source_id NUMBER)
2557: IS
2558: SELECT tpl.tap_id
2559: FROM okl_txl_ap_inv_lns_b tpl
2560: WHERE TPL.ID = p_source_id;
2561:
2562: CURSOR get_tap_details_csr (p_source_id NUMBER)
2563: IS
2568: ,tap.try_id try_id
2569: ,tap.vendor_invoice_number trans_number
2570: ,tll.description trans_line_description
2571: FROM okl_trx_ap_invoices_b tap
2572: ,okl_txl_ap_inv_lns_b tpl
2573: ,okl_txl_ap_inv_lns_tl tll
2574: WHERE tll.id = tpl.id
2575: AND tap.id = tpl.tap_id
2576: AND tpl.id = p_source_id;