DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on AP_LOOKUP_CODES

Line 578: ap_lookup_codes lc

574: 'N', lc.displayed_field)
575: INTO l_batch_name
576: FROM fnd_profile_option_values fpov1,
577: fnd_profile_options fpo1,
578: ap_lookup_codes lc
579: WHERE fpov1.profile_option_id = fpo1.profile_option_id
580: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'
581: AND fpov1.level_id = 10004
582: AND lc.lookup_type ='NLS REPORT PARAMETER'

Line 592: from ap_lookup_codes lc

588: l_use_batch_controls := fnd_profile.value('AP_USE_INV_BATCH_CONTROLS');
589: if nvl(l_use_batch_controls,'N') = 'N' then
590: select lc.displayed_field
591: into l_batch_name
592: from ap_lookup_codes lc
593: where lc.lookup_type = 'NLS REPORT PARAMETER'
594: and lc.lookup_code = 'NA';
595: end if;
596: --End of code addition for bug#6926296