DBA Data[Home] [Help]

APPS.APRX_PY dependencies on FND_LOOKUPS

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

409:
410: --
411: -- This bind variable was included in the select list.
412: --
413: select substrb(meaning,1,10) into l_nls_yes from fnd_lookups
414: where lookup_type='YES_NO' and lookup_code='Y';
415: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
416: where lookup_type='YES_NO' and lookup_code='N';
417: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');

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

411: -- This bind variable was included in the select list.
412: --
413: select substrb(meaning,1,10) into l_nls_yes from fnd_lookups
414: where lookup_type='YES_NO' and lookup_code='Y';
415: select substrb(meaning,1,10) into l_nls_no from fnd_lookups
416: where lookup_type='YES_NO' and lookup_code='N';
417: fa_rx_util_pkg.debug('Binding b_nls_yes and b_nls_no.');
418: dbms_sql.bind_variable(c, 'b_nls_yes', l_nls_yes);
419: dbms_sql.bind_variable(c, 'b_nls_no', l_nls_no);