DBA Data[Home] [Help]

APPS.QP_VALIDATE dependencies on QP_LOOKUPS

Line 1422: FROM QP_LOOKUPS

1418: END IF;
1419:
1420: SELECT LOOKUP_CODE
1421: INTO l_dummy
1422: FROM QP_LOOKUPS
1423: WHERE LOOKUP_TYPE = 'LIST_TYPE_CODE'
1424: AND LOOKUP_CODE = p_list_type_code
1425: AND ROWNUM < 2;
1426:

Line 5626: FROM QP_LOOKUPS

5622: END IF;
5623:
5624: SELECT lookup_code
5625: INTO l_dummy
5626: FROM QP_LOOKUPS
5627: WHERE lookup_type = 'COMPARISON_OPERATOR'
5628: AND lookup_code = p_comparison_operator_code;
5629:
5630: RETURN TRUE;

Line 12284: FROM QP_LOOKUPS

12280: END IF;
12281:
12282: SELECT lookup_code
12283: INTO l_dummy
12284: FROM QP_LOOKUPS
12285: WHERE lookup_type = 'QP_LIMIT_BASIS'
12286: AND lookup_code = p_basis;
12287:
12288: RETURN TRUE;

Line 12334: FROM QP_LOOKUPS

12330: END IF;
12331:
12332: SELECT lookup_code
12333: INTO l_dummy
12334: FROM QP_LOOKUPS
12335: WHERE lookup_type = 'LIMIT_EXCEED_ACTION'
12336: AND lookup_code = p_limit_exceed_action_code;
12337:
12338: RETURN TRUE;

Line 12486: FROM QP_LOOKUPS

12482: END IF;
12483:
12484: SELECT lookup_code
12485: INTO l_dummy
12486: FROM QP_LOOKUPS
12487: WHERE lookup_type = 'LIMIT_LEVEL'
12488: AND lookup_code = p_limit_level_code;
12489:
12490: RETURN TRUE;

Line 13113: FROM QP_LOOKUPS

13109: END IF;
13110:
13111: SELECT lookup_code
13112: INTO l_dummy
13113: FROM QP_LOOKUPS
13114: WHERE lookup_type = 'LIMIT_ATTRIBUTE_TYPE'
13115: AND lookup_code = p_limit_attribute_type;
13116:
13117: RETURN TRUE;