52: SELECT
53: MEANING
54: INTO LP_ACTIVE_ONLY
55: FROM
56: FND_LOOKUPS
57: WHERE LOOKUP_TYPE = 'YES_NO'
58: AND LOOKUP_CODE = UPPER(SUBSTR(P_ACTIVE_MODIFIER_ONLY
59: ,1
60: ,1));
61: SELECT
62: MEANING
63: INTO LP_ACTIVE_LINES_ONLY
64: FROM
65: FND_LOOKUPS
66: WHERE LOOKUP_TYPE = 'YES_NO'
67: AND LOOKUP_CODE = UPPER(SUBSTR(P_ACTIVE_MODIFIER_LINES
68: ,1
69: ,1));