APPS.HR_US_REPORTS dependencies on BEN_BENEFIT_CLASSIFICATIONS

Line 1143: v_benefit_class_name ben_benefit_classifications.benefit_classification_name%type;

1139: FUNCTION get_ben_class_name
1140: (p_session_date DATE,
1141: p_benefit_classification_id NUMBER) return VARCHAR2 IS
1142: --
1143: v_benefit_class_name ben_benefit_classifications.benefit_classification_name%type;
1144: --
1145: begin
1146: hr_utility.trace('Entered hr_reports.get_ben_class_name');
1147: --

Line 1156: from ben_benefit_classifications

1152: begin
1153: hr_utility.set_location('hr_reports.get_ben_class_name',10);
1154: select benefit_classification_name
1155: into v_benefit_class_name
1156: from ben_benefit_classifications
1157: where benefit_classification_id = p_benefit_classification_id;
1158: exception
1159: when no_data_found then RETURN NULL;
1160: end;