[Home] [Help]
66: and compliance_env_id = p_compliance_env_id;
67:
68: select meaning
69: into yes
70: from fnd_lookups
71: where lookup_type='YES_NO'
72: and lookup_code='Y';
73:
74: select meaning
72: and lookup_code='Y';
73:
74: select meaning
75: into no
76: from fnd_lookups
77: where lookup_type='YES_NO'
78: and lookup_code='N';
79:
80: if n > 0 then