APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;

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;
965: l_qte_id okl_k_lines.qte_id%type := null;
966: l_chk_qte_id okl_k_lines.qte_id%type := null;

Line 982: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP

978: where id1 = p_fee_types_rec.party_id1;
979:
980: CURSOR l_ft_general_item_id_csr IS
981: select OKL_STRMTYP.id1
982: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP
983: where OKL_STRMTYP.name = p_fee_types_rec.item_name
984: and OKL_STRMTYP.STATUS = 'A';
985:
986: Cursor l_ft_capitalized_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 1034: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP

1030: AND sty_name = p_fee_types_rec.item_name;
1031:
1032: CURSOR l_item_name_csr IS
1033: select name
1034: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP
1035: where OKL_STRMTYP.id1 = p_fee_types_rec.item_id1
1036: and OKL_STRMTYP.STATUS = 'A';
1037:
1038: cursor l_start_date_csr IS