DBA Data[Home] [Help]

APPS.APRX_PY dependencies on FND_LOOKUPS

Line 332: select substrb(meaning,1,10) into l_nls_yes from fnd_lookups

328:
329: --
330: -- This bind variable was included in the select list.
331: --
332: select substrb(meaning,1,10) into l_nls_yes from fnd_lookups
333: where lookup_type='YES_NO' and lookup_code='Y';
334: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
335: where lookup_type='YES_NO' and lookup_code='N';
336: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');

Line 334: select substrb(meaning,1,10) into l_nls_no from fnd_lookups

330: -- This bind variable was included in the select list.
331: --
332: select substrb(meaning,1,10) into l_nls_yes from fnd_lookups
333: where lookup_type='YES_NO' and lookup_code='Y';
334: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
335: where lookup_type='YES_NO' and lookup_code='N';
336: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
337: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
338: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);