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 955: l_pdt_id okl_k_headers.pdt_id%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;
958: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;
959: l_khr_id okl_k_headers.khr_id%type := null;

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

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

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
978: SELECT sty_id
979: FROM okl_strm_tmpt_full_uv
980: WHERE nvl(CAPITALIZE_YN,'N') = 'Y'
981: AND STY_PURPOSE = 'EXPENSE'

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

983: AND trunc(p_start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE)
984: AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),p_start_date+1)
985: AND sty_name = p_fee_types_rec.item_name;
986:
987: Cursor l_ft_income_item_id_csr(p_pdt_id okl_k_headers.pdt_id%type, p_start_date date) IS
988: SELECT sty_id
989: FROM okl_strm_tmpt_full_uv
990: WHERE STY_PURPOSE = 'FEE_PAYMENT'
991: AND pdt_id = p_pdt_id

Line 996: Cursor l_ft_passthrough_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_passthrough_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 = 'PASS_THROUGH_FEE'
1000: AND pdt_id = p_pdt_id

Line 1005: Cursor l_ft_secdeposit_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_secdeposit_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 = 'SECURITY_DEPOSIT'
1009: AND pdt_id = p_pdt_id

Line 1014: Cursor l_ft_others_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_others_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 = 'EXPENSE'
1018: AND pdt_id = p_pdt_id

Line 1031: from okc_k_headers_b chr, okl_k_headers khr

1027: and OKL_STRMTYP.STATUS = 'A';
1028:
1029: cursor l_start_date_csr IS
1030: select chr.start_date, khr.pdt_id
1031: from okc_k_headers_b chr, okl_k_headers khr
1032: where chr.id = p_fee_types_rec.dnz_chr_id
1033: and chr.id = khr.id;
1034:
1035: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS

Line 1049: okl_k_headers khr

1045: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS
1046: SELECT rqt.rollover_quote
1047: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1048: OKC_K_HEADERS_B chr,
1049: okl_k_headers khr
1050: WHERE chr.id = khr.id
1051: and chr.currency_code = rqt.currency_code
1052: and CHR.CUST_ACCT_ID = rqt.cust_acct_id
1053: AND rqt.qte_id = p_fee_types_rec.qte_id

Line 1062: okl_k_headers khr

1058: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1059: SELECT rqt.rollover_quote
1060: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1061: OKC_K_HEADERS_B chr,
1062: okl_k_headers khr
1063: WHERE chr.id = khr.id
1064: and chr.currency_code = rqt.currency_code
1065: and CHR.CUST_ACCT_ID = rqt.cust_acct_id
1066: AND rqt.qte_id = p_fee_types_rec.qte_id

Line 1074: from okl_k_headers

1070: and chr.id = p_fee_types_rec.dnz_chr_id;
1071:
1072: CURSOR l_khr_id_csr IS
1073: select khr_id
1074: from okl_k_headers
1075: where id = p_fee_types_rec.dnz_chr_id;
1076:
1077: CURSOR l_chk_roll_qt_upd_csr(p_qte_id okl_k_lines.qte_id%type) IS
1078: select 1

Line 5393: FROM OKL_K_HEADERS_FULL_V

5389: --Bug# 4524091
5390: CURSOR get_k_details_csr ( p_chr_id IN number ) IS
5391: SELECT
5392: START_DATE, END_DATE, ORIG_SYSTEM_SOURCE_CODE
5393: FROM OKL_K_HEADERS_FULL_V
5394: WHERE id = p_chr_id;
5395:
5396:
5397:

Line 5405: okl_k_headers khr,

5401: CURSOR get_pricing_engine_csr (p_chr_id IN NUMBER) IS
5402: SELECT
5403: gts.pricing_engine
5404: FROM
5405: okl_k_headers khr,
5406: okl_products_v pdt,
5407: okl_ae_tmpt_sets_v aes,
5408: OKL_ST_GEN_TMPT_SETS gts
5409: WHERE