APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_SUBSIDIES_B

Line 27156: l_subsidy_id okl_subsidies_b.id%TYPE;

27152: WHERE line_type = 'ASSET_SUBSIDY'
27153: AND contract_number_old = p_contract_number
27154: AND asset_number = p_asset_number;
27155:
27156: l_subsidy_id okl_subsidies_b.id%TYPE;
27157: l_vendor_id okl_subsidies_b.vendor_id%TYPE;
27158: l_paysite_id NUMBER;
27159: l_payterm_id NUMBER;
27160:

Line 27157: l_vendor_id okl_subsidies_b.vendor_id%TYPE;

27153: AND contract_number_old = p_contract_number
27154: AND asset_number = p_asset_number;
27155:
27156: l_subsidy_id okl_subsidies_b.id%TYPE;
27157: l_vendor_id okl_subsidies_b.vendor_id%TYPE;
27158: l_paysite_id NUMBER;
27159: l_payterm_id NUMBER;
27160:
27161: l_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

Line 27172: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,

27168: SELECT vendor_id
27169: FROM po_vendors
27170: WHERE vendor_name = p_name;
27171:
27172: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
27173: p_org NUMBER) IS
27174: SELECT id
27175: FROM okl_subsidies_b
27176: WHERE name = p_name

Line 27175: FROM okl_subsidies_b

27171:
27172: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
27173: p_org NUMBER) IS
27174: SELECT id
27175: FROM okl_subsidies_b
27176: WHERE name = p_name
27177: AND org_id = p_org;
27178:
27179: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,