APPS.QP_VALIDATE_QUALIFIERS dependencies on QP_QUALIFIERS

Line 18: FROM QP_QUALIFIERS

14: p_start_date date,
15: p_qualifier_rule_id number,
16: p_qualifier_id number) is
17: SELECT 'CHANGED'
18: FROM QP_QUALIFIERS
19: WHERE qualifier_rule_id = p_qualifier_rule_id
20: AND qualifier_grouping_no = p_qualifier_grouping_no
21: AND start_date_active <> p_start_date
22: AND qualifier_id <> p_qualifier_id;

Line 58: FROM QP_QUALIFIERS

54: p_end_date date,
55: p_qualifier_rule_id number,
56: p_qualifier_id number ) is
57: SELECT 'CHANGED'
58: FROM QP_QUALIFIERS
59: WHERE qualifier_rule_id = p_qualifier_rule_id
60: AND qualifier_grouping_no = p_qualifier_grouping_no
61: AND end_date_active <> p_end_date
62: AND qualifier_id <> p_qualifier_id;

Line 558: FROM QP_QUALIFIERS

554:
555:
556: /* SELECT qualifier_id
557: INTO l_qualifier_id
558: FROM QP_QUALIFIERS
559: WHERE qualifier_id = p_QUALIFIERS_rec.qualifier_id;
560:
561: If SQL%NOTFOUND
562: Then

Line 1802: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN

1798:
1799: -- Validate descriptive flexfield.
1800:
1801: --dbms_output.put_line('validating flex ');
1802: IF NOT QP_Validate.Desc_Flex( 'QP_QUALIFIERS' ) THEN
1803: x_return_status := FND_API.G_RET_STS_ERROR;
1804: END IF;
1805: --dbms_output.put_line('status is '||x_return_status);
1806: