[Home] [Help]
59: and component_code = P_COMPONENT_CODE;
60:
61: select meaning
62: into yes
63: from fnd_lookups
64: where lookup_type='YES_NO'
65: and lookup_code='Y';
66:
67: select meaning
65: and lookup_code='Y';
66:
67: select meaning
68: into no
69: from fnd_lookups
70: where lookup_type='YES_NO'
71: and lookup_code='N';
72:
73: if n > 0 then