36: return FALSE;
37: end;
38: /** bug 2343583 **/
39: Select nvl(adjusting_revenue_flag,'N') into adj_flag
40: from pa_draft_revenues_all where project_id = X_project_id and
41: draft_revenue_num = X_draft_revenue_num;
42: begin
43: select null
44: into dummy
92: end;
93:
94: /** bug 2343583 **/
95: Select nvl(adjusting_revenue_flag,'N') into adj_flag
96: from pa_draft_revenues_all where project_id = X_project_id and
97: draft_revenue_num = X_draft_revenue_num;
98:
99: begin
100: select null