DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_RBS_ELEMENT_NAMES_VL

Line 3215: l_return_value pa_rbs_element_names_vl.resource_name%TYPE;

3211: FUNCTION get_rbs_element_name_from_id
3212: (p_rbs_element_version_id IN pa_rbs_elements.rbs_element_id%TYPE)
3213: return VARCHAR2
3214: IS
3215: l_return_value pa_rbs_element_names_vl.resource_name%TYPE;
3216: BEGIN
3217: select names.resource_name
3218: into l_return_value
3219: from pa_rbs_elements ele,

Line 3220: pa_rbs_element_names_vl names

3216: BEGIN
3217: select names.resource_name
3218: into l_return_value
3219: from pa_rbs_elements ele,
3220: pa_rbs_element_names_vl names
3221: where ele.rbs_element_id = p_rbs_element_version_id and
3222: ele.rbs_element_name_id = names.rbs_element_name_id;
3223: return l_return_value;
3224: EXCEPTION