DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_RBS_ELEMENT_NAMES_VL

Line 3259: l_return_value pa_rbs_element_names_vl.resource_name%TYPE;

3255: FUNCTION get_rbs_element_name_from_id
3256: (p_rbs_element_version_id IN pa_rbs_elements.rbs_element_id%TYPE)
3257: return VARCHAR2
3258: IS
3259: l_return_value pa_rbs_element_names_vl.resource_name%TYPE;
3260: BEGIN
3261: select names.resource_name
3262: into l_return_value
3263: from pa_rbs_elements ele,

Line 3264: pa_rbs_element_names_vl names

3260: BEGIN
3261: select names.resource_name
3262: into l_return_value
3263: from pa_rbs_elements ele,
3264: pa_rbs_element_names_vl names
3265: where ele.rbs_element_id = p_rbs_element_version_id and
3266: ele.rbs_element_name_id = names.rbs_element_name_id;
3267: return l_return_value;
3268: EXCEPTION