DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on FND_LOOKUP_VALUES

Line 920: (select meaning from FND_LOOKUP_VALUES where lookup_type = 'INVOICE TYPE'

916: -- cursor to get header details gl_date, description,invoice type and exchange information
917: Cursor c_hdr_info(p_invoice_id Number) IS
918: select app.Description,
919: app.GL_date,
920: (select meaning from FND_LOOKUP_VALUES where lookup_type = 'INVOICE TYPE'
921: and view_application_id =200 and language = USERENV('LANG') and lookup_code=app.invoice_type_lookup_code) invoice_type,
922: (select min(psd.due_date) from ap_payment_schedules_all psd where psd.invoice_id=app.invoice_id) earliest_due_date,
923: app.exchange_rate_type,
924: (select user_conversion_type from GL_DAILY_CONVERSION_TYPES where conversion_type=app.exchange_rate_type) exchange_rate_type1,-- Bug 8904838