DBA Data[Home] [Help]

APPS.BSC_UPDATE_UTIL dependencies on BSC_LOOKUPS

Line 2633: ' FROM bsc_lookups'||

2629:
2630: /*
2631: c_lookup_value t_cursor; -- x_lookup_type, x_lookup_code
2632: c_lookup_value_sql VARCHAR2(2000) := 'SELECT meaning'||
2633: ' FROM bsc_lookups'||
2634: ' WHERE lookup_type = :1 AND lookup_code = :2';
2635: */
2636:
2637: h_lookup_value VARCHAR2(4000);

Line 2658: FROM bsc_lookups

2654: */
2655: BEGIN
2656: SELECT meaning
2657: INTO h_lookup_value
2658: FROM bsc_lookups
2659: WHERE lookup_type = x_lookup_type AND lookup_code = x_lookup_code;
2660: EXCEPTION
2661: WHEN NO_DATA_FOUND THEN
2662: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_LOOKUP_VALUES');