APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on FND_LOOKUP_VALUES

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

117: /*
118: ||Get the meaning for a corresponding lookup_type and lookup_code
119: || TBD - Check effectivity for regime end date
120: */
121: CURSOR c_get_lookup_meaning ( cp_lookup_type FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE ,
122: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE
123: )
124: IS
125: SELECT

Line 122: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE

118: ||Get the meaning for a corresponding lookup_type and lookup_code
119: || TBD - Check effectivity for regime end date
120: */
121: CURSOR c_get_lookup_meaning ( cp_lookup_type FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE ,
122: cp_lookup_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE
123: )
124: IS
125: SELECT
126: meaning

Line 128: fnd_lookup_values

124: IS
125: SELECT
126: meaning
127: FROM
128: fnd_lookup_values
129: WHERE
130: lookup_type = cp_lookup_type AND
131: lookup_code = cp_lookup_code;
132:

Line 152: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;

148: upper(attribute_code) = upper(cp_tax_type);
149:
150: lv_exists VARCHAR2(2) ;
151: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
152: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
153: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
154:
155: BEGIN
156:

Line 153: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;

149:
150: lv_exists VARCHAR2(2) ;
151: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
152: lv_meaning FND_LOOKUP_VALUES.MEANING%TYPE ;
153: lv_meaning_rgm FND_LOOKUP_VALUES.MEANING%TYPE ;
154:
155: BEGIN
156:
157: /*################################################################################################################