APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_STRMTYP_SOURCE_V

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

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

Line 973: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP

969: where id1 = p_fee_types_rec.party_id1;
970:
971: CURSOR l_ft_general_item_id_csr IS
972: select OKL_STRMTYP.id1
973: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP
974: where OKL_STRMTYP.name = p_fee_types_rec.item_name
975: and OKL_STRMTYP.STATUS = 'A';
976:
977: Cursor l_ft_capitalized_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

Line 1025: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP

1021: AND sty_name = p_fee_types_rec.item_name;
1022:
1023: CURSOR l_item_name_csr IS
1024: select name
1025: from OKL_STRMTYP_SOURCE_V OKL_STRMTYP
1026: where OKL_STRMTYP.id1 = p_fee_types_rec.item_id1
1027: and OKL_STRMTYP.STATUS = 'A';
1028:
1029: cursor l_start_date_csr IS