DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_XTL_PAY_INVS_ALL_B

Line 71: ,okl_xtl_pay_invs_all_b xlp

67: CURSOR c_num_csr ( p_id NUMBER ) IS
68: SELECT CHR.CONTRACT_NUMBER
69: FROM okc_k_headers_b chr
70: ,okl_txl_ap_inv_lns_all_b tpl
71: ,okl_xtl_pay_invs_all_b xlp
72: WHERE XLP.ID = p_id
73: AND XLP.tpl_id = TPL.id
74: AND TPL.khr_id = chr.id;
75:

Line 86: ,okl_xtl_pay_invs_all_b xlp

82: SELECT CHR.CONTRACT_NUMBER
83: FROM okc_k_headers_b chr
84: ,okl_trx_ap_invoices_b tap
85: ,okl_txl_ap_inv_lns_all_b tpl
86: ,okl_xtl_pay_invs_all_b xlp
87: WHERE XLP.XPI_ID_DETAILS = p_id
88: AND XLP.tap_id = TAP.id
89: AND tpl.tap_id = tap.id
90: AND tpl.khr_id = chr.id; */