APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKX_VENDORS_V

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

946: l_api_name CONSTANT VARCHAR2(30) := 'validate_fee_type';
947: l_api_version CONSTANT NUMBER := 1.0;
948: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
949:
950: l_supp_id okx_vendors_v.id1%type := null;
951: l_party_name okx_vendors_v.name%type := null;
952: l_item_id NUMBER:= null;
953: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
954: l_start_date okc_k_headers_b.start_date%type := null;

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

947: l_api_version CONSTANT NUMBER := 1.0;
948: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
949:
950: l_supp_id okx_vendors_v.id1%type := null;
951: l_party_name okx_vendors_v.name%type := null;
952: l_item_id NUMBER:= null;
953: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
954: l_start_date okc_k_headers_b.start_date%type := null;
955: l_pdt_id okl_k_headers.pdt_id%type := null;

Line 963: from okx_vendors_v

959: l_khr_id okl_k_headers.khr_id%type := null;
960:
961: CURSOR l_supp_name_csr IS
962: select id1
963: from okx_vendors_v
964: where name = p_fee_types_rec.party_name;
965:
966: CURSOR l_supp_id1_csr IS
967: select name

Line 968: from okx_vendors_v

964: where name = p_fee_types_rec.party_name;
965:
966: CURSOR l_supp_id1_csr IS
967: select name
968: from okx_vendors_v
969: where id1 = p_fee_types_rec.party_id1;
970:
971: CURSOR l_ft_general_item_id_csr IS
972: select OKL_STRMTYP.id1