DBA Data[Home] [Help]

APPS.IGS_FI_PRC_APINT dependencies on AP_LOOKUP_CODES

Line 184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,

180: || agairola 11-Mar-2003 Bug 2838757: Initialized g_b_data_found
181: || to false
182: || (reverse chronological order - newest change first)
183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type

Line 185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS

181: || to false
182: || (reverse chronological order - newest change first)
183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type
189: AND lookup_code = cp_lookup_code;

Line 187: FROM ap_lookup_codes

183: ******************************************************************/
184: CURSOR c_lkp(cp_lookup_type ap_lookup_codes.lookup_type%TYPE,
185: cp_lookup_code ap_lookup_codes.lookup_code%TYPE) IS
186: SELECT displayed_field
187: FROM ap_lookup_codes
188: WHERE lookup_type = cp_lookup_type
189: AND lookup_code = cp_lookup_code;
190: BEGIN
191: