DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on AP_LOOKUP_CODES

Line 588: ap_lookup_codes lc

584: 'N', lc.displayed_field)
585: INTO l_batch_name
586: FROM fnd_profile_option_values fpov1,
587: fnd_profile_options fpo1,
588: ap_lookup_codes lc
589: WHERE fpov1.profile_option_id = fpo1.profile_option_id
590: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'
591: AND fpov1.level_id = 10004
592: AND lc.lookup_type ='NLS REPORT PARAMETER'

Line 602: from ap_lookup_codes lc

598: l_use_batch_controls := fnd_profile.value('AP_USE_INV_BATCH_CONTROLS');
599: if nvl(l_use_batch_controls,'N') = 'N' then
600: select lc.displayed_field
601: into l_batch_name
602: from ap_lookup_codes lc
603: where lc.lookup_type = 'NLS REPORT PARAMETER'
604: and lc.lookup_code = 'NA';
605: end if;
606: --End of code addition for bug#6926296