APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 6526: FROM okl_trx_ap_invoices_b tap

6522: -- Cursor to fetch trans number
6523: CURSOR c_trans_number_csr (p_header_source_id NUMBER)
6524: IS
6525: SELECT tap.vendor_invoice_number trans_number
6526: FROM okl_trx_ap_invoices_b tap
6527: WHERE tap.id = p_header_source_id;
6528:
6529: -----------------------------------------------------------------
6530: -- Declare Process Variable

Line 7139: FROM okl_trx_ap_invoices_b tap

7135: ,tpl.kle_id kle_id
7136: ,tpl.sty_id sty_id
7137: ,tap.try_id try_id
7138: ,tap.vendor_invoice_number trans_number
7139: FROM okl_trx_ap_invoices_b tap
7140: ,okl_txl_ap_inv_lns_b tpl
7141: WHERE tap.id = tpl.tap_id
7142: AND tap.id = p_header_source_id;
7143:

Line 7216: -- ie. it should be okl_trx_ap_invoices_b only

7212: END IF;
7213:
7214: -- Validation 2: The Header Source Table should be the
7215: -- OKL AP Invoice Trx Header . Header table only
7216: -- ie. it should be okl_trx_ap_invoices_b only
7217: IF (p_pxhv_rec.source_table <> G_TRX_AP_INVOICES_B)
7218: THEN
7219: OKL_API.set_message(
7220: p_app_name => G_APP_NAME