109: p_legislation_code VARCHAR2)
110: IS
111: SELECT fat.application_name application_name
112: FROM fnd_application fa,
113: fnd_application_tl fat
114: WHERE fa.application_id = fat.application_id
115: AND fa.application_short_name = p_application_short_name
116: AND fat.language = p_legislation_code;
117: -- ********************************************************************_