APPS.IBY_FORMULA_PKG dependencies on IBY_RISK_FACTORS

Line 70: FROM iby_risk_factors

66: FROM DUAL;
67:
68: CURSOR c_factor_id( ci_factor_name VARCHAR2) is
69: SELECT risk_factor_id
70: FROM iby_risk_factors
71: WHERE risk_factor_code = ci_factor_name;
72:
73: l_formula_id integer;
74: l_factor_id integer;

Line 176: FROM iby_risk_factors

172: IS
173:
174: CURSOR c_factor_id( ci_factor_name VARCHAR2) is
175: SELECT risk_factor_id
176: FROM iby_risk_factors
177: WHERE risk_factor_code = ci_factor_name;
178:
179: l_formula_id integer;
180: l_factor_id integer;

Line 312: FROM iby_risk_factors irf, iby_risk_formula_item irft

308: WHERE risk_formula_id = ci_risk_formula_id;
309:
310: CURSOR c_factor(ci_factorid iby_risk_formula_item.risk_formula_id%type) IS
311: SELECT risk_factor_code, weight
312: FROM iby_risk_factors irf, iby_risk_formula_item irft
313: WHERE irft.risk_formula_id = i_formulaId
314: AND irf.risk_factor_id = irft.risk_factor_id;
315:
316: l_cnt integer;