APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_SUBSIDIES_B

Line 26884: l_subsidy_id okl_subsidies_b.id%TYPE;

26880: WHERE line_type = 'ASSET_SUBSIDY'
26881: AND contract_number_old = p_contract_number
26882: AND asset_number = p_asset_number;
26883:
26884: l_subsidy_id okl_subsidies_b.id%TYPE;
26885: l_vendor_id okl_subsidies_b.vendor_id%TYPE;
26886: l_paysite_id NUMBER;
26887: l_payterm_id NUMBER;
26888:

Line 26885: l_vendor_id okl_subsidies_b.vendor_id%TYPE;

26881: AND contract_number_old = p_contract_number
26882: AND asset_number = p_asset_number;
26883:
26884: l_subsidy_id okl_subsidies_b.id%TYPE;
26885: l_vendor_id okl_subsidies_b.vendor_id%TYPE;
26886: l_paysite_id NUMBER;
26887: l_payterm_id NUMBER;
26888:
26889: l_asb_rec okl_asset_subsidy_pvt.asb_rec_type;

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

26896: SELECT vendor_id
26897: FROM po_vendors
26898: WHERE vendor_name = p_name;
26899:
26900: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
26901: p_org NUMBER) IS
26902: SELECT id
26903: FROM okl_subsidies_b
26904: WHERE name = p_name

Line 26903: FROM okl_subsidies_b

26899:
26900: CURSOR sub_id_csr (p_name okl_subsidies_b.name%TYPE,
26901: p_org NUMBER) IS
26902: SELECT id
26903: FROM okl_subsidies_b
26904: WHERE name = p_name
26905: AND org_id = p_org;
26906:
26907: CURSOR paysite_csr (p_code po_vendor_sites_all.vendor_site_code%TYPE,