APPS.OKC_CONTRACT_PVT dependencies on OKC_RULES_B

Line 2127: SELECT ID FROM OKC_RULES_B

2123: WHERE cpl_Id=P_cpl_Id;
2124:
2125: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2126: P_Rule_Type IN Varchar2) IS
2127: SELECT ID FROM OKC_RULES_B
2128: WHERE Rgp_Id=P_Rgp_Id
2129: AND Rule_Information_category=P_rule_Type;
2130:
2131: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 2132: SELECT ID FROM OKC_RULES_B

2128: WHERE Rgp_Id=P_Rgp_Id
2129: AND Rule_Information_category=P_rule_Type;
2130:
2131: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
2132: SELECT ID FROM OKC_RULES_B
2133: WHERE Rgp_Id=P_Rgp_Id;
2134:
2135: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
2136: SELECT ID FROM OKC_RULE_GROUPS_B

Line 2582: SELECT ID FROM OKC_RULES_B

2578: WHERE cpl_Id=P_cpl_Id;
2579:
2580: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2581: P_Rule_Type IN Varchar2) IS
2582: SELECT ID FROM OKC_RULES_B
2583: WHERE Rgp_Id=P_Rgp_Id
2584: AND Rule_Information_category=P_rule_Type;
2585:
2586: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 2587: SELECT ID FROM OKC_RULES_B

2583: WHERE Rgp_Id=P_Rgp_Id
2584: AND Rule_Information_category=P_rule_Type;
2585:
2586: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
2587: SELECT ID FROM OKC_RULES_B
2588: WHERE Rgp_Id=P_Rgp_Id;
2589:
2590: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
2591: SELECT ID FROM OKC_RULE_GROUPS_B

Line 2716: FROM OKC_RULES_B

2712: L_RIC OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE;
2713:
2714: CURSOR l_ric_csr IS
2715: SELECT RULE_INFORMATION_CATEGORY
2716: FROM OKC_RULES_B
2717: WHERE ID = p_rulv_rec.id;
2718: l_col_vals okc_time_util_pub.t_col_vals;
2719:
2720: --