DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_LA_ROLLOVER_FEE_UV

Line 1046: FROM OKL_LA_ROLLOVER_FEE_UV rqt,

1042: and chr.id = khr.id;
1043:
1044: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS
1045: SELECT rqt.qte_id
1046: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1047: OKC_K_HEADERS_B chr
1048: WHERE CHR.CUST_ACCT_ID = rqt.cust_acct_id
1049: AND rqt.rollover_quote = p_fee_types_rec.roll_qt
1050: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))

Line 1056: FROM OKL_LA_ROLLOVER_FEE_UV rqt,

1052: AND chr.id = p_fee_types_rec.dnz_chr_id;
1053:
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

Line 1069: FROM OKL_LA_ROLLOVER_FEE_UV rqt,

1065: AND chr.id = p_fee_types_rec.dnz_chr_id;
1066:
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