APPS.OKS_COVERAGES_PVT dependencies on OKC_RULE_GROUPS_B

Line 2256: SELECT ID FROM OKC_RULE_GROUPS_B

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
2257: WHERE cle_Id=P_Cle_Id;
2258: */
2259:
2260: CURSOR Relobj_Cur(P_Cle_Id IN NUMBER) IS

Line 3849: SELECT ID FROM OKC_RULE_GROUPS_B

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
3850: WHERE cle_Id=P_Cle_Id;
3851:
3852: CURSOR Relobj_Cur(P_Cle_Id IN NUMBER) IS
3853: SELECT Id FROM OKC_K_REL_OBJS_V

Line 6089: OKC_RULE_GROUPS_B orgb,

6085: NVL(rules.TEMPLATE_YN,'N') TEMPLATE_YN
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)

Line 6306: OKC_RULE_GROUPS_B orgb,

6302: OKC_K_LINES_B lines1,
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)