APPS.HR_US_REPORTS dependencies on BEN_BENEFIT_CLASSIFICATIONS

Line 1125: v_benefit_class_name ben_benefit_classifications.benefit_classification_name%type;

1121: FUNCTION get_ben_class_name
1122: (p_session_date DATE,
1123: p_benefit_classification_id NUMBER) return VARCHAR2 IS
1124: --
1125: v_benefit_class_name ben_benefit_classifications.benefit_classification_name%type;
1126: --
1127: begin
1128: hr_utility.trace('Entered hr_reports.get_ben_class_name');
1129: --

Line 1138: from ben_benefit_classifications

1134: begin
1135: hr_utility.set_location('hr_reports.get_ben_class_name',10);
1136: select benefit_classification_name
1137: into v_benefit_class_name
1138: from ben_benefit_classifications
1139: where benefit_classification_id = p_benefit_classification_id;
1140: exception
1141: when no_data_found then RETURN NULL;
1142: end;