APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKX_VENDORS_V

Line 959: l_supp_id okx_vendors_v.id1%type := null;

955: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee_type';
956: l_api_version CONSTANT NUMBER := 1.0;
957: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
958:
959: l_supp_id okx_vendors_v.id1%type := null;
960: l_party_name okx_vendors_v.name%type := null;
961: l_item_id NUMBER:= null;
962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
963: l_start_date okc_k_headers_b.start_date%type := null;

Line 960: l_party_name okx_vendors_v.name%type := null;

956: l_api_version CONSTANT NUMBER := 1.0;
957: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
958:
959: l_supp_id okx_vendors_v.id1%type := null;
960: l_party_name okx_vendors_v.name%type := null;
961: l_item_id NUMBER:= null;
962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
963: l_start_date okc_k_headers_b.start_date%type := null;
964: l_pdt_id okl_k_headers.pdt_id%type := null;

Line 972: from okx_vendors_v

968: l_khr_id okl_k_headers.khr_id%type := null;
969:
970: CURSOR l_supp_name_csr IS
971: select id1
972: from okx_vendors_v
973: where name = p_fee_types_rec.party_name;
974:
975: CURSOR l_supp_id1_csr IS
976: select name

Line 977: from okx_vendors_v

973: where name = p_fee_types_rec.party_name;
974:
975: CURSOR l_supp_id1_csr IS
976: select name
977: from okx_vendors_v
978: where id1 = p_fee_types_rec.party_id1;
979:
980: CURSOR l_ft_general_item_id_csr IS
981: select OKL_STRMTYP.id1