DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE_ADJ dependencies on QP_LOOKUPS

Line 531: FROM QP_LOOKUPS

527:
528: BEGIN
529: SELECT 'VALID'
530: INTO l_tmp_string
531: FROM QP_LOOKUPS
532: WHERE LOOKUP_TYPE = p_Line_Adj_rec.charge_type_code
533: AND LOOKUP_CODE = p_Line_Adj_rec.charge_subtype_code
534: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,sysdate))
535: AND TRUNC(NVL(END_DATE_ACTIVE,sysdate))