APPS.QP_UTIL dependencies on QP_LIMIT_ATTRIBUTES

Line 217: SELECT 'Y' INTO x_is_used FROM qp_limit_attributes

213: AND multival_attribute2 = p_attribute_code)) AND rownum < 2;
214: EXCEPTION
215: WHEN no_data_found THEN
216: BEGIN
217: SELECT 'Y' INTO x_is_used FROM qp_limit_attributes
218: WHERE limit_attribute_context = p_context_code
219: AND limit_attribute = p_attribute_code AND rownum < 2;
220: EXCEPTiON
221: WHEN no_data_found THEN

Line 277: SELECT 'Y' INTO x_is_used FROM qp_limit_attributes

273: AND multival_attribute2 = p_attribute_code)) AND rownum < 2;
274: EXCEPTION
275: WHEN no_data_found THEN
276: BEGIN
277: SELECT 'Y' INTO x_is_used FROM qp_limit_attributes
278: WHERE limit_attribute_context = p_context_code
279: AND limit_attribute = p_attribute_code AND rownum < 2;
280: EXCEPTiON
281: WHEN no_data_found THEN

Line 308: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

304: EXCEPTION
305: WHEN no_data_found THEN
306: BEGIN
307: SELECT 'Y' INTO x_is_used
308: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
309: WHERE a.limit_attribute_context = p_context_code
310: AND a.limit_attribute = p_attribute_code AND a.limit_id = b.limit_id
311: AND b.list_header_id = c.list_header_id AND c.active_flag = 'Y'
312: AND rownum < 2;

Line 382: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c

378: EXCEPTION
379: WHEN no_data_found THEN
380: BEGIN
381: SELECT 'Y' INTO x_is_used
382: FROM qp_limit_attributes a, qp_limits b, qp_list_headers_b c
383: WHERE a.limit_attribute_context = p_context_code
384: AND a.limit_attribute = p_attribute_code AND a.limit_id = b.limit_id
385: AND b.list_header_id = c.list_header_id AND c.active_flag = 'Y'
386: AND rownum < 2;