APPS.QP_DENORMALIZED_PRICING_ATTRS dependencies on QP_LIST_LINES

Line 141: --Update the group_count column of qp_list_lines with the count of

137: l_list_line_id_tbl.DELETE; --Clear the plsql table.
138:
139:
140: IF l_list_header_id_tbl.COUNT > 0 THEN
141: --Update the group_count column of qp_list_lines with the count of
142: --pricing attributes which have search_ind = 2 for each list_line_id
143: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
144: UPDATE qp_list_lines l
145: SET l.group_count = (select count(*)

Line 144: UPDATE qp_list_lines l

140: IF l_list_header_id_tbl.COUNT > 0 THEN
141: --Update the group_count column of qp_list_lines with the count of
142: --pricing attributes which have search_ind = 2 for each list_line_id
143: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
144: UPDATE qp_list_lines l
145: SET l.group_count = (select count(*)
146: from qp_pricing_attributes a
147: where a.list_line_id = l.list_line_id
148: and a.search_ind = 2)