DBA Data[Home] [Help]

APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKC_RULE_GROUPS_V

Line 991: FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL

987:
988:
989: cursor c_rulecust_value (p_khr_id NUMBER) IS
990: SELECT RUL.RULE_INFORMATION1,RUL.RULE_INFORMATION2
991: FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL
992: WHERE GRUL.RGD_CODE = 'INSRUL'
993: AND RUL.RGP_ID = GRUL.ID
994: AND RUL.rule_information_category = 'INCUST'
995: AND GRUL.CHR_ID = p_khr_id ;

Line 999: FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL

995: AND GRUL.CHR_ID = p_khr_id ;
996:
997: cursor c_rulelessor_value (p_khr_id NUMBER)IS
998: SELECT RUL.RULE_INFORMATION1
999: FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL
1000: WHERE GRUL.RGD_CODE = 'INVRUL'
1001: AND RUL.RGP_ID = GRUL.ID
1002: AND RUL.rule_information_category = 'INVNIN'
1003: AND GRUL.CHR_ID = p_khr_id ;