APPS.CN_PLAN_ELEMENT_PUB dependencies on DBMS_LOB

Line 718: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,

714: IS
715: CURSOR get_exps
716: IS
717: SELECT calc_sql_exp_id,
718: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,
719: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp
720: FROM cn_calc_sql_exps
721: WHERE '|' || DBMS_LOB.SUBSTR (piped_sql_select) LIKE '%|(' || p_quota_id || 'PE.%';
722:

Line 719: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp

715: CURSOR get_exps
716: IS
717: SELECT calc_sql_exp_id,
718: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,
719: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp
720: FROM cn_calc_sql_exps
721: WHERE '|' || DBMS_LOB.SUBSTR (piped_sql_select) LIKE '%|(' || p_quota_id || 'PE.%';
722:
723: l_ss_start NUMBER;

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

717: SELECT calc_sql_exp_id,
718: DBMS_LOB.SUBSTR (piped_sql_select) sql_select,
719: DBMS_LOB.SUBSTR (piped_expression_disp) expr_disp
720: FROM cn_calc_sql_exps
721: WHERE '|' || DBMS_LOB.SUBSTR (piped_sql_select) LIKE '%|(' || p_quota_id || 'PE.%';
722:
723: l_ss_start NUMBER;
724: l_ss_end NUMBER;
725: l_ed_start NUMBER;