2060: WHERE dnz_chr_id = l_chr_id
2061: AND cle_Id=P_cle_Id;
2062:
2063: CURSOR Contact_Cur(P_cpl_Id IN NUMBER) IS
2064: SELECT ID FROM OKC_CONTACTS
2065: WHERE cpl_Id=P_cpl_Id;
2066:
2067: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2068: P_Rule_Type IN Varchar2) IS
2515: WHERE dnz_chr_id = l_chr_id
2516: AND cle_Id=P_cle_Id;
2517:
2518: CURSOR Contact_Cur(P_cpl_Id IN NUMBER) IS
2519: SELECT ID FROM OKC_CONTACTS
2520: WHERE cpl_Id=P_cpl_Id;
2521:
2522: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2523: P_Rule_Type IN Varchar2) IS