APPS.CN_PLAN_ELEMENT_PVT dependencies on DBMS_LOB

Line 816: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,

812: IS
813: CURSOR get_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:

Line 817: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp

813: CURSOR get_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;

Line 819: WHERE '|' || DBMS_LOB.SUBSTR (piped_sql_select) LIKE '%|(' || p_quota_id || 'PE.%';

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;
823: l_ed_start NUMBER;