DBA Data[Home] [Help]

APPS.AMS_DCF_LEADS_TITLE dependencies on FND_LOOKUP_VALUES

Line 46: fnd_lookup_values

42: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
43: select
44: meaning into vRepName
45: from
46: fnd_lookup_values
47: where
48: lookup_type= 'BIM_DBC_DCF_TITLES'
49: and lookup_code = vCompCode
50: and language = userenv('LANG');

Line 78: fnd_lookup_values

74: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
75: select
76: meaning into vRepName
77: from
78: fnd_lookup_values
79: where
80: lookup_type= 'BIM_DBC_DCF_TITLES'
81: and lookup_code = vCompCode
82: and language = userenv('LANG');

Line 115: fnd_lookup_values

111: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
112: select
113: meaning into vRepName
114: from
115: fnd_lookup_values
116: where
117: lookup_type= 'BIM_DBC_DCF_TITLES'
118: and lookup_code = vCompCode
119: and language = userenv('LANG');

Line 151: fnd_lookup_values

147: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
148: select
149: meaning into vRepName
150: from
151: fnd_lookup_values
152: where
153: lookup_type= 'BIM_DBC_DCF_TITLES'
154: and lookup_code = vCompCode
155: and language = userenv('LANG');

Line 187: fnd_lookup_values

183: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
184: select
185: meaning into vRepName
186: from
187: fnd_lookup_values
188: where
189: lookup_type= 'BIM_DBC_DCF_TITLES'
190: and lookup_code = vCompCode
191: and language = userenv('LANG');

Line 223: fnd_lookup_values

219: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
220: select
221: meaning into vRepName
222: from
223: fnd_lookup_values
224: where
225: lookup_type= 'BIM_DBC_DCF_TITLES'
226: and lookup_code = vCompCode
227: and language = userenv('LANG');

Line 259: fnd_lookup_values

255: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
256: select
257: meaning into vRepName
258: from
259: fnd_lookup_values
260: where
261: lookup_type= 'BIM_DBC_DCF_TITLES'
262: and lookup_code = vCompCode
263: and language = userenv('LANG');

Line 309: fnd_lookup_values

305: vCompCode := jtfb_dcf.get_parameter_value(p_parameters,'DCF.componentCode');
306: select
307: meaning into vRepName
308: from
309: fnd_lookup_values
310: where
311: lookup_type= 'BIM_DBC_DCF_TITLES'
312: and lookup_code = vCompCode
313: and language = userenv('LANG');