910: END;
911: BEGIN
912: SELECT us.table_owner || '/' || l_return
913: INTO l_return
914: FROM user_synonyms us
915: WHERE us.synonym_name = p_table_name;
916: EXCEPTION
917: WHEN no_data_found THEN
918: RETURN(line_return(l_return ||
915: WHERE us.synonym_name = p_table_name;
916: EXCEPTION
917: WHEN no_data_found THEN
918: RETURN(line_return(l_return ||
919: '/get_tbl(USER_SYNONYMS): no data found.'));
920: END;
921: RETURN(line_return(l_return));
922: EXCEPTION
923: WHEN no_data_found THEN
2543: SELECT us.table_owner || '/' ||
2544: ft.table_name || '/' ||
2545: To_char(table_id)
2546: INTO l_return
2547: FROM user_synonyms us, fnd_tables ft, fnd_descriptive_flexs df
2548: WHERE us.synonym_name = df.application_table_name
2549: AND ft.application_id = df.table_application_id
2550: AND ft.table_name = df.application_table_name
2551: AND df.application_id = p_application_id
3721: SELECT us.table_owner || '/' ||
3722: ft.table_name || '/' ||
3723: To_char(table_id)
3724: INTO l_return
3725: FROM user_synonyms us, fnd_tables ft, fnd_id_flexs idf
3726: WHERE us.synonym_name = idf.application_table_name
3727: AND ft.application_id = idf.table_application_id
3728: AND ft.table_name = idf.application_table_name
3729: AND idf.application_id = p_application_id