APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on FND_LOOKUP_VALUES

Line 423: CURSOR c_get_lookup_meaning ( cp_lookup_type FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE ,

419: /*
420: ||Get the meaning for a corresponding lookup_type and lookup_code
421: || TBD - Check effectivity for regime end date
422: */
423: CURSOR c_get_lookup_meaning ( cp_lookup_type FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE ,
424: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE
425: )
426: IS
427: SELECT

Line 424: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE

420: ||Get the meaning for a corresponding lookup_type and lookup_code
421: || TBD - Check effectivity for regime end date
422: */
423: CURSOR c_get_lookup_meaning ( cp_lookup_type FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE ,
424: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE
425: )
426: IS
427: SELECT
428: meaning

Line 430: fnd_lookup_values

426: IS
427: SELECT
428: meaning
429: FROM
430: fnd_lookup_values
431: WHERE
432: lookup_type = cp_lookup_type AND
433: lookup_code = cp_lookup_code;
434:

Line 454: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;

450: upper(attribute_code) = upper(cp_tax_type);
451:
452: lv_exists VARCHAR2(2) ;
453: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
454: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
455: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
456:
457: BEGIN
458:

Line 455: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;

451:
452: lv_exists VARCHAR2(2) ;
453: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
454: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
455: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
456:
457: BEGIN
458:
459: /*################################################################################################################