DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on FND_LOOKUPS

Line 825: FROM FND_LOOKUPS lookups

821: fnd_global.user_id,
822: SYSDATE,
823: FND_GLOBAL.CONC_LOGIN_ID,
824: 1
825: FROM FND_LOOKUPS lookups
826: WHERE lookups.LOOKUP_TYPE = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
827: AND NOT EXISTS -- this condition makes sure we dont duplicate data
828: (select NULL
829: from ZX_FC_CODES_B Codes

Line 4069: FROM FND_LOOKUPS lookups

4065: SYSDATE,
4066: FND_GLOBAL.CONC_LOGIN_ID,
4067: 1
4068:
4069: FROM FND_LOOKUPS lookups
4070: WHERE
4071:
4072: lookups.lookup_type='JLCL_AP_DOCUMENT_TYPE'
4073: AND NOT EXISTS -- this condition makes sure we dont duplicate data

Line 4387: FROM FND_LOOKUPS lookups

4383: (SELECT
4384: lookups.LOOKUP_CODE fc_code,
4385: nvl(START_DATE_ACTIVE,to_date('01/01/1951','DD/MM/YYYY')) effective_from,
4386: END_DATE_ACTIVE effective_to
4387: FROM FND_LOOKUPS lookups
4388: WHERE
4389: (lookups.LOOKUP_TYPE = 'TRANSACTION_CLASS' or
4390: lookups.LOOKUP_TYPE = 'TRANSACTION_REASON')
4391: ) lookups