APPS.OKS_COVERAGES_PVT dependencies on OKC_RULES_B

Line 2247: SELECT ID FROM OKC_RULES_B

2243:
2244: /*
2245: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
2246: P_Rule_Type IN Varchar2) IS
2247: SELECT ID FROM OKC_RULES_B
2248: WHERE Rgp_Id=P_Rgp_Id
2249: AND Rule_Information_category=P_rule_Type;
2250:
2251: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 2252: SELECT ID FROM OKC_RULES_B

2248: WHERE Rgp_Id=P_Rgp_Id
2249: AND Rule_Information_category=P_rule_Type;
2250:
2251: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
2252: SELECT ID FROM OKC_RULES_B
2253: WHERE Rgp_Id=P_Rgp_Id;
2254:
2255: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
2256: SELECT ID FROM OKC_RULE_GROUPS_B

Line 3840: SELECT ID FROM OKC_RULES_B

3836: WHERE cpl_Id=P_cpl_Id;
3837:
3838: CURSOR TRule_Cur( P_Rgp_Id IN NUMBER,
3839: P_Rule_Type IN Varchar2) IS
3840: SELECT ID FROM OKC_RULES_B
3841: WHERE Rgp_Id=P_Rgp_Id
3842: AND Rule_Information_category=P_rule_Type;
3843:
3844: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS

Line 3845: SELECT ID FROM OKC_RULES_B

3841: WHERE Rgp_Id=P_Rgp_Id
3842: AND Rule_Information_category=P_rule_Type;
3843:
3844: CURSOR Rl_Cur(P_Rgp_Id IN NUMBER) IS
3845: SELECT ID FROM OKC_RULES_B
3846: WHERE Rgp_Id=P_Rgp_Id;
3847:
3848: CURSOR Rgp_Cur(P_cle_Id IN NUMBER) IS
3849: SELECT ID FROM OKC_RULE_GROUPS_B

Line 6090: OKC_RULES_B rules

6086: FROM
6087: OKC_K_LINES_B lines1,
6088: OKC_K_LINES_B lines2,
6089: OKC_RULE_GROUPS_B orgb,
6090: OKC_RULES_B rules
6091: WHERE
6092: lines1.lse_id IN (5,23,59)
6093: AND lines2.lse_id IN (6,24,60)
6094: AND lines1.dnz_chr_id = lines2.dnz_chr_id

Line 6175: UPDATE okc_rules_b

6171: END IF;
6172:
6173: x_return_status := l_return_status;
6174:
6175: UPDATE okc_rules_b
6176: SET rule_information9 = 'Y'
6177: WHERE id = br_rec.rule_id ;
6178:
6179: END LOOP ;

Line 6307: OKC_RULES_B rules,

6303: OKC_K_LINES_B lines2,
6304: OKC_K_LINES_B lines3,
6305: OKC_K_ITEMS items,
6306: OKC_RULE_GROUPS_B orgb,
6307: OKC_RULES_B rules,
6308: OKS_BILLRATE_SCHEDULES bills
6309: WHERE
6310: lines1.lse_id IN (3,16,21)
6311: and lines2.lse_id IN (5,23,59)

Line 6548: UPDATE okc_rules_b

6544: -- update the rule line with mapped status to Y
6545:
6546:
6547: -- code commented to fix bug#2954917 for charges integration
6548: UPDATE okc_rules_b
6549: SET rule_information9 = 'Y'
6550: WHERE id = bill_rate_rec.rule_id ;
6551:
6552: /* l_rulv_tbl_in(1).id := bill_rate_rec.rule_id ;