APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_REACT_INTERVALS

Line 580: FROM OKC_REACT_INTERVALS ril

576: WHERE cti.rul_id = p_rul_rec.id;
577:
578: CURSOR l_ril_csr IS
579: SELECT 'x'
580: FROM OKC_REACT_INTERVALS ril
581: WHERE ril.rul_id = p_rul_rec.id;
582:
583: CURSOR l_rgr_csr IS
584: -- SELECT NVL(rgr.optional_yn, 'N')

Line 897: -- There must be at least on child record in OKC_REACT_INTERVALS for a rule

893: x_return_status := OKC_API.G_RET_STS_ERROR;
894: END IF;
895: END IF;
896:
897: -- There must be at least on child record in OKC_REACT_INTERVALS for a rule
898: IF (p_rul_rec.rule_information_category = 'RCN') THEN
899: l_dummy := '?';
900: -- check for record in cover times
901: OPEN l_ril_csr;