[Home] [Help]
78: WHEN NO_DATA_FOUND THEN
79: BEGIN
80: IF p_project_role_id is not null then
81: SELECT default_job_id into x_job_id
82: FROM pa_project_role_types_vl role
83: WHERE role.project_role_id = p_project_role_id
84: AND ROWNUM = 1;
85: END IF;
86: EXCEPTION