[Home] [Help]
53: WHERE xpi_id_details = p_xpi_id;
54:
55: cursor c_cnsld_hdr(p_cnsld_ap_inv_id IN NUMBER) IS
56: SELECT self_bill_inv_num
57: FROM okl_cnsld_ap_invs
58: WHERE cnsld_ap_inv_id = p_cnsld_ap_inv_id;
59:
60: CURSOR c_taxable_yn(p_tpl_id IN NUMBER) IS
61: SELECT taxable_yn
451: ,r_invoice_hdr.pay_group_lookup_code
452: -- 01-NOV-2006 ANSETHUR R12B - Legal Entity
453: ,r_invoice_hdr.legal_entity_id
454: ,fnd_global.prog_appl_id
455: ,'OKL_CNSLD_AP_INVS_ALL'
456: ,r_invoice_hdr.cnsld_ap_inv_id
457: ,l_self_bill_invnum
458: ,'Y'
459: --Bug# 11705655