DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 6411: FROM okl_trx_ap_invoices_b tap

6407: -- Cursor to fetch trans number
6408: CURSOR c_trans_number_csr (p_header_source_id NUMBER)
6409: IS
6410: SELECT tap.vendor_invoice_number trans_number
6411: FROM okl_trx_ap_invoices_b tap
6412: WHERE tap.id = p_header_source_id;
6413:
6414: -----------------------------------------------------------------
6415: -- Declare Process Variable

Line 7024: FROM okl_trx_ap_invoices_b tap

7020: ,tpl.kle_id kle_id
7021: ,tpl.sty_id sty_id
7022: ,tap.try_id try_id
7023: ,tap.vendor_invoice_number trans_number
7024: FROM okl_trx_ap_invoices_b tap
7025: ,okl_txl_ap_inv_lns_b tpl
7026: WHERE tap.id = tpl.tap_id
7027: AND tap.id = p_header_source_id;
7028:

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

7097: END IF;
7098:
7099: -- Validation 2: The Header Source Table should be the
7100: -- OKL AP Invoice Trx Header . Header table only
7101: -- ie. it should be okl_trx_ap_invoices_b only
7102: IF (p_pxhv_rec.source_table <> G_TRX_AP_INVOICES_B)
7103: THEN
7104: OKL_API.set_message(
7105: p_app_name => G_APP_NAME