55: FUNCTION get_project(p_assignment_id NUMBER,
56: p_earned_date DATE)
57: return varchar2 IS
58:
59: l_project_number pa_projects_all.segment1%TYPE;
60:
61: begin
62: if pa_pay_util.g_expenditure_item_id is not null then
63: select segment1
61: begin
62: if pa_pay_util.g_expenditure_item_id is not null then
63: select segment1
64: into l_project_number
65: from pa_projects_all
66: where project_id = (select project_id
67: from pa_expenditure_items_all
68: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
69: