DBA Data[Home] [Help]

APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKC_K_LINES_B

Line 727: CURSOR rollover_fee_line_csr(p_k_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

723:
724: -- Start Manu 11-Aug-2004.
725: -- Cursor to find if there are any Rollover Fee lines on a contract
726:
727: CURSOR rollover_fee_line_csr(p_k_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
728: SELECT 1 FROM okc_k_lines_b CLEB, okl_k_lines KLE
729: WHERE CLEB.dnz_chr_id = p_k_id
730: AND KLE.FEE_TYPE = 'ROLLOVER'
731: AND KLE.ID = CLEB.ID

Line 728: SELECT 1 FROM okc_k_lines_b CLEB, okl_k_lines KLE

724: -- Start Manu 11-Aug-2004.
725: -- Cursor to find if there are any Rollover Fee lines on a contract
726:
727: CURSOR rollover_fee_line_csr(p_k_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
728: SELECT 1 FROM okc_k_lines_b CLEB, okl_k_lines KLE
729: WHERE CLEB.dnz_chr_id = p_k_id
730: AND KLE.FEE_TYPE = 'ROLLOVER'
731: AND KLE.ID = CLEB.ID
732: AND NOT EXISTS (