APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 65: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b

61: SELECT taxable_yn
62: FROM okl_txl_ap_inv_lns_b
63: WHERE id = p_tpl_id;
64:
65: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b
66: -- changes made as part of OKLR12B disbursements project
67: CURSOR c_num_csr ( p_id NUMBER ) IS
68: SELECT CHR.CONTRACT_NUMBER
69: FROM okc_k_headers_b chr

Line 78: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b

74: AND TPL.khr_id = chr.id;
75:
76:
77: -- XLP.tpl_id has tap_id
78: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b
79: -- changes made as part of OKLR12B disbursements project
80: /* rkuttiya commented this cursor as no longer required */
81: /* CURSOR c_fun_csr ( p_id NUMBER ) IS
82: SELECT CHR.CONTRACT_NUMBER

Line 84: ,okl_trx_ap_invoices_b tap

80: /* rkuttiya commented this cursor as no longer required */
81: /* CURSOR c_fun_csr ( p_id NUMBER ) IS
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

Line 104: , okl_trx_ap_invoices_b tap

100: CURSOR c_try_name(p_tpl_id IN NUMBER) IS
101: SELECT try.name try_name,
102: tpl.sty_id
103: FROM okl_txl_ap_inv_lns_b tpl
104: , okl_trx_ap_invoices_b tap
105: , okl_trx_types_v try
106: WHERE tpl.id = p_tpl_id
107: AND tpl.tap_id = tap.id
108: AND tap.try_id = try.id;

Line 133: , okl_trx_ap_invoices_b tap

129: , kle.dnz_chr_id khr_id
130: -- , try.name try_name -- cklee 06/19/2007
131: FROM OKC_K_LINES_B kle
132: , okl_txl_ap_inv_lns_b tpl
133: , okl_trx_ap_invoices_b tap
134: , okl_trx_types_v try
135: WHERE tpl.id = p_tpl_id
136: AND tpl.kle_id = kle.id
137: AND tpl.tap_id = tap.id