205:
206: cursor allocation_def_edt is
207: select '1'
208: from (select member,rule_name,method,basis,qualifier
209: from zpb_solve_allocation_defs
210: where analysis_cycle_id = p_analysis_cycle_id
211: minus
212: select member,rule_name,method,basis,qualifier
213: from zpb_solve_allocation_defs
209: from zpb_solve_allocation_defs
210: where analysis_cycle_id = p_analysis_cycle_id
211: minus
212: select member,rule_name,method,basis,qualifier
213: from zpb_solve_allocation_defs
214: where analysis_cycle_id = l_pub_ac_id);
215:
216: cursor allocation_def_pub is
217: select '1'
215:
216: cursor allocation_def_pub is
217: select '1'
218: from (select member,rule_name,method,basis,qualifier,evaluation_option
219: from zpb_solve_allocation_defs
220: where analysis_cycle_id = l_pub_ac_id
221: minus
222: select member,rule_name,method,basis,qualifier,evaluation_option
223: from zpb_solve_allocation_defs
219: from zpb_solve_allocation_defs
220: where analysis_cycle_id = l_pub_ac_id
221: minus
222: select member,rule_name,method,basis,qualifier,evaluation_option
223: from zpb_solve_allocation_defs
224: where analysis_cycle_id = p_analysis_cycle_id);
225:
226: cursor task_list is
227: select '1'