DBA Data[Home] [Help]

APPS.PA_PAY_UTIL dependencies on PA_PROJECTS_ALL

Line 59: l_project_number pa_projects_all.segment1%TYPE;

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

Line 65: from pa_projects_all

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: