DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 572: (p_proj_assignment_id IN pa_project_assignments.assignment_id%TYPE) return VARCHAR2 is

568: return null;
569: END get_supplier_name;
570:
571: FUNCTION get_schedule_role_name
572: (p_proj_assignment_id IN pa_project_assignments.assignment_id%TYPE) return VARCHAR2 is
573: l_return_value VARCHAR2(80) := 'invalid value';
574: BEGIN
575: select assignment_name
576: into l_return_value

Line 577: from pa_project_assignments

573: l_return_value VARCHAR2(80) := 'invalid value';
574: BEGIN
575: select assignment_name
576: into l_return_value
577: from pa_project_assignments
578: where assignment_id = p_proj_assignment_id;
579: return l_return_value;
580: EXCEPTION
581: when NO_DATA_FOUND then