8653:
8654: CURSOR c_system_options(p_org_id IN NUMBER) IS
8655: SELECT B.NAME
8656: FROM OKL_SYSTEM_PARAMS_ALL A,
8657: OKL_FORMULAE_B B
8658: WHERE A.ORG_ID = p_org_id
8659: AND A.FORMULA_ID = B.ID (+);
8660:
8661: l_formula_name OKL_FORMULAE_B.NAME%TYPE;
8657: OKL_FORMULAE_B B
8658: WHERE A.ORG_ID = p_org_id
8659: AND A.FORMULA_ID = B.ID (+);
8660:
8661: l_formula_name OKL_FORMULAE_B.NAME%TYPE;
8662:
8663: l_id NUMBER;
8664: l_ret_exists VARCHAR2(1);
8665: l_count NUMBER;