eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_K_HEADERS

Line 964: l_pdt_id okl_k_headers.pdt_id%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;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
968: l_khr_id okl_k_headers.khr_id%type := null;

Line 968: l_khr_id okl_k_headers.khr_id%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;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
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

Line 986: Cursor l_ft_capitalized_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

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
987: SELECT sty_id
988: FROM okl_strm_tmpt_full_uv
989: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
990: AND STY_PURPOSE = 'EXPENSE'

Line 996: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

992: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
993: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
994: AND sty_name = p_fee_types_rec.item_name;
995:
996: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
997: SELECT sty_id
998: FROM okl_strm_tmpt_full_uv
999: WHERE STY_PURPOSE = 'FEE_PAYMENT'
1000: AND pdt_id = p_pdt_id

Line 1005: Cursor l_ft_passthrough_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

1001: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1002: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1003: AND sty_name = p_fee_types_rec.item_name;
1004:
1005: Cursor l_ft_passthrough_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1006: SELECT sty_id
1007: FROM okl_strm_tmpt_full_uv
1008: WHERE STY_PURPOSE = 'PASS_THROUGH_FEE'
1009: AND pdt_id = p_pdt_id

Line 1014: Cursor l_ft_secdeposit_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

1010: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1011: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1012: AND sty_name = p_fee_types_rec.item_name;
1013:
1014: Cursor l_ft_secdeposit_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1015: SELECT sty_id
1016: FROM okl_strm_tmpt_full_uv
1017: WHERE STY_PURPOSE = 'SECURITY_DEPOSIT'
1018: AND pdt_id = p_pdt_id

Line 1023: Cursor l_ft_others_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS

1019: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
1020: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
1021: AND sty_name = p_fee_types_rec.item_name;
1022:
1023: Cursor l_ft_others_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
1024: SELECT sty_id
1025: FROM okl_strm_tmpt_full_uv
1026: WHERE STY_PURPOSE = 'EXPENSE'
1027: AND pdt_id = p_pdt_id

Line 1040: from okc_k_headers_b chr, okl_k_headers khr

1036: and OKL_STRMTYP.STATUS = 'A';
1037:
1038: cursor l_start_date_csr IS
1039: select chr.start_date, khr.pdt_id
1040: from okc_k_headers_b chr, okl_k_headers khr
1041: where chr.id = p_fee_types_rec.dnz_chr_id
1042: and chr.id = khr.id;
1043:
1044: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS

Line 1058: okl_k_headers khr

1054: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS
1055: SELECT rqt.rollover_quote
1056: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1057: OKC_K_HEADERS_B chr,
1058: okl_k_headers khr
1059: WHERE chr.id = khr.id
1060: and chr.currency_code = rqt.currency_code
1061: and CHR.CUST_ACCT_ID = rqt.cust_acct_id
1062: AND rqt.qte_id = p_fee_types_rec.qte_id

Line 1071: okl_k_headers khr

1067: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1068: SELECT rqt.rollover_quote
1069: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1070: OKC_K_HEADERS_B chr,
1071: okl_k_headers khr
1072: WHERE chr.id = khr.id
1073: and chr.currency_code = rqt.currency_code
1074: and CHR.CUST_ACCT_ID = rqt.cust_acct_id
1075: AND rqt.qte_id = p_fee_types_rec.qte_id

Line 1083: from okl_k_headers

1079: and chr.id = p_fee_types_rec.dnz_chr_id;
1080:
1081: CURSOR l_khr_id_csr IS
1082: select khr_id
1083: from okl_k_headers
1084: where id = p_fee_types_rec.dnz_chr_id;
1085:
1086: CURSOR l_chk_roll_qt_upd_csr(p_qte_id okl_k_lines.qte_id%type) IS
1087: select 1

Line 5406: FROM OKL_K_HEADERS_FULL_V

5402: --Bug# 4524091
5403: CURSOR get_k_details_csr ( p_chr_id IN number ) IS
5404: SELECT
5405: START_DATE, END_DATE, ORIG_SYSTEM_SOURCE_CODE, ORIG_SYSTEM_ID1
5406: FROM OKL_K_HEADERS_FULL_V
5407: WHERE id = p_chr_id;
5408:
5409:
5410:

Line 5418: okl_k_headers khr,

5414: CURSOR get_pricing_engine_csr (p_chr_id IN NUMBER) IS
5415: SELECT
5416: gts.pricing_engine
5417: FROM
5418: okl_k_headers khr,
5419: okl_products_v pdt,
5420: okl_ae_tmpt_sets_v aes,
5421: OKL_ST_GEN_TMPT_SETS gts
5422: WHERE