DBA Data[Home] [Help]

APPS.OKL_RULE_EXTRACT_PVT dependencies on OKC_RULES_B

Line 758: FROM OKC_RULE_GROUPS_B RG, OKC_RULES_B RL

754:
755: CURSOR HEADER_RULE_CSR(P_CONTRACT_ID IN OKC_K_HEADERS_B.ID%TYPE,
756: P_RGD_CODE IN VARCHAR2, P_RULE_CODE IN VARCHAR2) IS
757: SELECT RL.*
758: FROM OKC_RULE_GROUPS_B RG, OKC_RULES_B RL
759: WHERE RG.DNZ_CHR_ID = P_CONTRACT_ID
760: AND RG.CHR_ID = P_CONTRACT_ID
761: AND RG.RGD_CODE = P_RGD_CODE
762: AND RG.ID = RL.RGP_ID

Line 769: FROM OKC_RULE_GROUPS_B RG, OKC_RULES_B RL

765: CURSOR LINE_RULE_CSR(P_CONTRACT_ID IN OKC_K_HEADERS_B.ID%TYPE,
766: P_LINE_ID IN OKC_K_LINES_B.ID%TYPE,
767: P_RGD_CODE IN VARCHAR2, P_RULE_CODE IN VARCHAR2) IS
768: SELECT RL.*
769: FROM OKC_RULE_GROUPS_B RG, OKC_RULES_B RL
770: WHERE RG.DNZ_CHR_ID = P_CONTRACT_ID
771: AND RG.CHR_ID IS NULL
772: AND RG.CLE_ID = P_LINE_ID
773: AND RG.RGD_CODE = P_RGD_CODE