DBA Data[Home] [Help]

APPS.QP_VALIDATE_QUALIFIERS dependencies on DUAL

Line 26: FROM DUAL

22: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM
23: OR p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL
24: THEN
25: SELECT 1 INTO l_count
26: FROM DUAL
27: WHERE EXISTS( SELECT qualifier_id
28: FROM qp_qualifiers
29: WHERE qualifier_rule_id = p_QUALIFIERS_rec.qualifier_rule_id
30: AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no

Line 40: FROM DUAL

36: nvl(p_QUALIFIERS_rec.qualifier_attr_value_to,FND_API.G_MISS_NUM)
37: AND qualifier_id <> p_QUALIFIERS_rec.qualifier_id );
38: ELSE
39: SELECT 1 INTO l_count
40: FROM DUAL
41: WHERE EXISTS ( SELECT qualifier_id
42: FROM qp_qualifiers
43: WHERE list_header_id = p_QUALIFIERS_rec.list_header_id
44: AND qualifier_grouping_no = p_QUALIFIERS_rec.qualifier_grouping_no