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 5627: FROM QP_LOOKUPS

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

Line 12285: FROM QP_LOOKUPS

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

Line 12335: FROM QP_LOOKUPS

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

Line 12487: FROM QP_LOOKUPS

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

Line 13114: FROM QP_LOOKUPS

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