APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_CALC_SQL_EXPS

Line 818: FROM cn_calc_sql_exps

814: IS
815: SELECT calc_sql_exp_id,
816: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,
817: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp
818: FROM cn_calc_sql_exps
819: WHERE '|' || DBMS_LOB.SUBSTR (piped_sql_select) LIKE '%|(' || p_quota_id || 'PE.%';
820:
821: l_ss_start NUMBER;
822: l_ss_end NUMBER;

Line 870: UPDATE cn_calc_sql_exps

866: l_ed_start := l_ed_end + 1;
867: END LOOP;
868:
869: -- update table
870: UPDATE cn_calc_sql_exps
871: SET expression_disp = l_new_expr_disp,
872: piped_expression_disp = l_new_pexpr_disp
873: WHERE calc_sql_exp_id = e.calc_sql_exp_id;
874: END LOOP;