124: WHERE p.task_id = p_pa_task_id;
125:
126: --Declared these constants for bug 2833255. These variables will contain
127: --the truncated values for p_budget_start_date_in and p_budget_end_date_in
128: l_budget_start_date_in pa_budget_lines.start_date%TYPE :=trunc(p_budget_start_date_in);
129: l_budget_end_date_in pa_budget_lines.end_date%TYPE :=trunc(p_budget_end_date_in);
130:
131: -- Bug 3986129: FP.M Web ADI Dev changes, new variables
132: valid_gl_start_date VARCHAR2(1) := 'N';
125:
126: --Declared these constants for bug 2833255. These variables will contain
127: --the truncated values for p_budget_start_date_in and p_budget_end_date_in
128: l_budget_start_date_in pa_budget_lines.start_date%TYPE :=trunc(p_budget_start_date_in);
129: l_budget_end_date_in pa_budget_lines.end_date%TYPE :=trunc(p_budget_end_date_in);
130:
131: -- Bug 3986129: FP.M Web ADI Dev changes, new variables
132: valid_gl_start_date VARCHAR2(1) := 'N';
133: valid_gl_end_date VARCHAR2(1) := 'N';