DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on PO_VENDOR_SITES_ALL

Line 29: l_vendor_id po_vendor_sites_all.vendor_id%TYPE;

25: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER';
26: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
27: l_self_bill_invnum VARCHAR2(150);
28: l_contract_number VARCHAR2(120);
29: l_vendor_id po_vendor_sites_all.vendor_id%TYPE;
30: l_amount_includes_tax_flag po_vendor_sites_all.amount_includes_tax_flag%TYPE;
31: l_taxable_yn VARCHAR2(1);
32:
33: --start:| 16-Oct-2007 cklee -- Fixed bug:6502786 |

Line 30: l_amount_includes_tax_flag po_vendor_sites_all.amount_includes_tax_flag%TYPE;

26: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
27: l_self_bill_invnum VARCHAR2(150);
28: l_contract_number VARCHAR2(120);
29: l_vendor_id po_vendor_sites_all.vendor_id%TYPE;
30: l_amount_includes_tax_flag po_vendor_sites_all.amount_includes_tax_flag%TYPE;
31: l_taxable_yn VARCHAR2(1);
32:
33: --start:| 16-Oct-2007 cklee -- Fixed bug:6502786 |
34: CURSOR c_account_derivation IS

Line 94: FROM po_vendor_sites_all povs

90: AND tpl.khr_id = chr.id; */
91:
92: CURSOR v_id_csr( p_site_id NUMBER ) IS
93: SELECT povs.vendor_id
94: FROM po_vendor_sites_all povs
95: WHERE povs.vendor_site_id = p_site_id;
96:
97: --start:| 19-Jun-2007 cklee -- 1. Revert Tax call back |
98: --| 2. Fixed try_id, kle_id issues |