DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_DES_CHART_CELLS

Line 9198: FROM cz_des_chart_cells

9194: --in bulk and then transform it into another form in memory. This way we don't need any SQL ordering.
9195:
9196: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9197: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_featureid, tl_modelrefexplid
9198: FROM cz_des_chart_cells
9199: WHERE deleted_flag = '0'
9200: AND rule_id = this_rule_id;
9201:
9202: FOR i IN 1..tl_primaryoptid.COUNT LOOP

Line 9342: FROM cz_des_chart_cells

9338: END IF;
9339:
9340: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9341: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_secondaryfeatid, tl_secondaryfeatexplid
9342: FROM cz_des_chart_cells
9343: WHERE deleted_flag = '0'
9344: AND rule_id = this_rule_id;
9345:
9346: FOR i IN 1..tl_primaryoptid.COUNT LOOP