APPS.CN_SFP_ROLE_UTIL_PVT dependencies on CN_CALC_FORMULAS_ALL
Line 47: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_CALC_FORMULAS_ALL WHERE CALC_FORMULA_ID = l_calc_formula_id and org_id = l_org_id;
43: END IF;
44: END IF;
45:
46: IF l_calc_formula_id IS NOT NULL THEN 47: SELECT NVL(ORG_ID,-99) INTO l_temp_org FROM CN_CALC_FORMULAS_ALL WHERE CALC_FORMULA_ID = l_calc_formula_id and org_id = l_org_id; 48: IF l_temp_org <> l_org_id THEN
49: l_formula_pass := 'N';
50: EXIT;
51: END IF;