APPS.AMW_CONTROLS_PAGE_PKG dependencies on FND_LOOKUPS

Line 41: from fnd_lookups

37: and objective_code = P_OBJECTIVE_CODE;
38:
39: select meaning
40: into yes
41: from fnd_lookups
42: where lookup_type='YES_NO'
43: and lookup_code='Y';
44:
45: select meaning

Line 47: from fnd_lookups

43: and lookup_code='Y';
44:
45: select meaning
46: into no
47: from fnd_lookups
48: where lookup_type='YES_NO'
49: and lookup_code='N';
50:
51: if n > 0 then

Line 136: from fnd_lookups

132: and assertion_code = P_ASSERTION_CODE;
133:
134: select meaning
135: into yes
136: from fnd_lookups
137: where lookup_type='YES_NO'
138: and lookup_code='Y';
139:
140: select meaning

Line 142: from fnd_lookups

138: and lookup_code='Y';
139:
140: select meaning
141: into no
142: from fnd_lookups
143: where lookup_type='YES_NO'
144: and lookup_code='N';
145:
146: if n > 0 then

Line 191: from fnd_lookups

187: and component_code = P_component_CODE;
188:
189: select meaning
190: into yes
191: from fnd_lookups
192: where lookup_type='YES_NO'
193: and lookup_code='Y';
194:
195: select meaning

Line 197: from fnd_lookups

193: and lookup_code='Y';
194:
195: select meaning
196: into no
197: from fnd_lookups
198: where lookup_type='YES_NO'
199: and lookup_code='N';
200:
201: if n > 0 then

Line 1069: from fnd_lookups

1065: and PURPOSE_code = P_PURPOSE_CODE;
1066:
1067: select meaning
1068: into yes
1069: from fnd_lookups
1070: where lookup_type='YES_NO'
1071: and lookup_code='Y';
1072:
1073: select meaning

Line 1075: from fnd_lookups

1071: and lookup_code='Y';
1072:
1073: select meaning
1074: into no
1075: from fnd_lookups
1076: where lookup_type='YES_NO'
1077: and lookup_code='N';
1078:
1079: if n > 0 then