APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on QP_LIMITS

Line 47: from qp_limits qlim

43: FROM qp_list_headers_b qh
44: WHERE qh.active_flag = 'Y'
45: and qh.list_type_code in ('PRO','DLT','SLT','DEL','CHARGES')
46: and exists (select 'Y'
47: from qp_limits qlim
48: where qlim.list_header_id = qh.list_header_id)
49: and rownum = 1;
50: l_HVOP_Possible VARCHAR2(1) := 'Y';
51: dummy BOOLEAN;

Line 232: from qp_limits qlim

228: FROM qp_list_headers_b qh
229: WHERE qh.active_flag = 'Y'
230: and qh.list_type_code in ('PRO','DLT','SLT','DEL','CHARGES')
231: and exists (select 'Y'
232: from qp_limits qlim
233: where qlim.list_header_id = qh.list_header_id)
234: and rownum = 1;
235:
236: -- Essilor Fix bug 2789138