DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER_ADJ dependencies on QP_LOOKUPS

Line 259: FROM QP_LOOKUPS

255:
256: BEGIN
257: SELECT 'VALID'
258: INTO l_tmp_string
259: FROM QP_LOOKUPS
260: WHERE LOOKUP_TYPE = p_Header_Adj_rec.charge_type_code
261: AND LOOKUP_CODE = p_Header_Adj_rec.charge_subtype_code
262: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,sysdate))
263: AND TRUNC(NVL(END_DATE_ACTIVE,sysdate))