APPS.OKC_CONTRACT_PVT dependencies on OKC_RULES_B

Line 2069: SELECT ID FROM OKC_RULES_B

2065: WHERE cpl_Id=P_cpl_Id;
2066:
2067: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2068: P_Rule_Type IN Varchar2) IS
2069: SELECT ID FROM OKC_RULES_B
2070: WHERE Rgp_Id=P_Rgp_Id
2071: AND Rule_Information_category=P_rule_Type;
2072:
2073: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 2074: SELECT ID FROM OKC_RULES_B

2070: WHERE Rgp_Id=P_Rgp_Id
2071: AND Rule_Information_category=P_rule_Type;
2072:
2073: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
2074: SELECT ID FROM OKC_RULES_B
2075: WHERE Rgp_Id=P_Rgp_Id;
2076:
2077: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
2078: SELECT ID FROM OKC_RULE_GROUPS_B

Line 2524: SELECT ID FROM OKC_RULES_B

2520: WHERE cpl_Id=P_cpl_Id;
2521:
2522: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2523: P_Rule_Type IN Varchar2) IS
2524: SELECT ID FROM OKC_RULES_B
2525: WHERE Rgp_Id=P_Rgp_Id
2526: AND Rule_Information_category=P_rule_Type;
2527:
2528: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 2529: SELECT ID FROM OKC_RULES_B

2525: WHERE Rgp_Id=P_Rgp_Id
2526: AND Rule_Information_category=P_rule_Type;
2527:
2528: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
2529: SELECT ID FROM OKC_RULES_B
2530: WHERE Rgp_Id=P_Rgp_Id;
2531:
2532: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
2533: SELECT ID FROM OKC_RULE_GROUPS_B

Line 2658: FROM OKC_RULES_B

2654: L_RIC OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
2655:
2656: CURSOR l_ric_csr IS
2657: SELECT RULE_INFORMATION_CATEGORY
2658: FROM OKC_RULES_B
2659: WHERE ID = p_rulv_rec.id;
2660: l_col_vals okc_time_util_pub.t_col_vals;
2661:
2662: --