DBA Data[Home] [Help]

APPS.CZ_FCE_COMPILE dependencies on CZ_DES_CHART_CELLS

Line 9332: FROM cz_des_chart_cells

9328: --in bulk and then transform it into another form in memory. This way we don't need any SQL ordering.
9329:
9330: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9331: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_featureid, tl_modelrefexplid
9332: FROM cz_des_chart_cells
9333: WHERE deleted_flag = '0'
9334: AND rule_id = this_rule_id;
9335:
9336: FOR i IN 1..tl_primaryoptid.COUNT LOOP

Line 9476: FROM cz_des_chart_cells

9472: END IF;
9473:
9474: SELECT primary_opt_id, secondary_opt_id, secondary_feature_id, secondary_feat_expl_id
9475: BULK COLLECT INTO tl_primaryoptid, tl_secondaryoptid, tl_secondaryfeatid, tl_secondaryfeatexplid
9476: FROM cz_des_chart_cells
9477: WHERE deleted_flag = '0'
9478: AND rule_id = this_rule_id;
9479:
9480: FOR i IN 1..tl_primaryoptid.COUNT LOOP