DBA Data[Home] [Help]

APPS.JGRX_WT dependencies on PO_LOOKUP_CODES

Line 535: * lookup_type and lookup_code in po_lookup_codes, *

531: /**************************************************************************
532: * *
533: * Name : get_lookup_meaning *
534: * Purpose : This function returns the meaning for the matching *
535: * lookup_type and lookup_code in po_lookup_codes, *
536: * fnd_lookups using a memory structure. *
537: * *
538: **************************************************************************/
539:

Line 994: from po_lookup_codes

990: **************************************************************************/
991: PROCEDURE build_gbl_lookup_table is
992: cursor lookup_meaning_cursor is
993: Select 'PO', lookup_type, lookup_code, displayed_field
994: from po_lookup_codes
995: where lookup_type in ('ORGANIZATION TYPE')
996: and sysdate < nvl(inactive_date, sysdate+1)
997: union all
998: select 'FND',lookup_type, lookup_code, meaning