APPS.CN_CALC_FORMULAS_PVT dependencies on CN_LOOKUPS

Line 24: l_prompt cn_lookups.meaning%TYPE;

20: p_org_id IN CN_CALC_FORMULAS.ORG_ID%TYPE
21: --R12 MOAC Changes--End
22: ) IS
23:
24: l_prompt cn_lookups.meaning%TYPE;
25: l_dummy NUMBER;
26:
27: CURSOR formula_exists IS
28: SELECT 1

Line 639: FROM cn_calc_formulas cf, cn_lookups cl,

635: SELECT cf.calc_formula_id, cf.NAME, cf.FORMULA_TYPE, cf.TRX_GROUP_CODE,
636: cf.SPLIT_FLAG, cf.CUMULATIVE_FLAG, cf.ITD_FLAG, cf.MODELING_FLAG, cl.MEANING,
637: cf.output_exp_id, cf.f_output_exp_id, cf.perf_measure_id, cs1.name oname,
638: cs2.name fname, cs3.name pname
639: FROM cn_calc_formulas cf, cn_lookups cl,
640: cn_calc_sql_exps cs1, cn_calc_sql_exps cs2, cn_calc_sql_exps cs3
641: WHERE cl.lookup_code = cf.FORMULA_TYPE
642: AND cl.lookup_type = 'FORMULA_TYPE'
643: AND cf.OUTPUT_EXP_ID = cs1.CALC_SQL_EXP_ID (+)

Line 884: FROM cn_calc_formulas cf, cn_lookups cl

880: END IF;
881:
882: IF (l_old_rec.formula_type <> p_formula_type) THEN
883: SELECT meaning into l_meaning
884: FROM cn_calc_formulas cf, cn_lookups cl
885: WHERE cl.lookup_code = cf.FORMULA_TYPE
886: AND cl.lookup_type = 'FORMULA_TYPE'
887: AND calc_formula_id = p_calc_formula_id;
888:

Line 937: FROM cn_lookups

933:
934: IF (l_old_rec.split_flag <> p_split_flag) THEN
935:
936: SELECT meaning into l_new_meaning
937: FROM cn_lookups
938: WHERE lookup_type = 'SPLIT_FLAG'
939: AND lookup_code = p_split_flag;
940:
941: SELECT meaning into l_old_meaning

Line 942: FROM cn_lookups

938: WHERE lookup_type = 'SPLIT_FLAG'
939: AND lookup_code = p_split_flag;
940:
941: SELECT meaning into l_old_meaning
942: FROM cn_lookups
943: WHERE lookup_type = 'SPLIT_FLAG'
944: AND lookup_code = l_old_rec.split_flag;
945:
946: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_SPLIT_UPD');