[Home] [Help]
85: ) IS
86:
87: BEGIN
88:
89: delete from qp_list_header_phases
90: where list_header_id = p_List_Header_ID;
91:
92: insert into qp_list_header_phases
93: (list_header_id, pricing_phase_id)
88:
89: delete from qp_list_header_phases
90: where list_header_id = p_List_Header_ID;
91:
92: insert into qp_list_header_phases
93: (list_header_id, pricing_phase_id)
94: (
95: select distinct list_header_id , pricing_phase_id
96: from qp_list_lines