129: from ap_exp_report_dists_all dist
130: where report_header_id = p_report_header_id
131: and report_line_id not in (
132: select report_line_id
133: from ap_expense_report_lines_all line
134: where line.report_header_id = dist.report_header_id
135: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
136:
137: -----------------------------------------------------
143: from ap_exp_report_dists_all dist
144: where report_header_id = p_report_header_id
145: and report_line_id not in (
146: select report_line_id
147: from ap_expense_report_lines_all line
148: where line.report_header_id = dist.report_header_id
149: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
150:
151: l_approver_id := AP_WEB_AME_PKG.getAwardManagerID(l_award_id, nvl(l_week_end_date,trunc(sysdate)));
172: from ap_exp_report_dists_all dist
173: where report_header_id = p_report_header_id
174: and report_line_id not in (
175: select report_line_id
176: from ap_expense_report_lines_all line
177: where line.report_header_id = dist.report_header_id
178: and web_parameter_id in (l_personalParameterId, l_roundingParameterId));
179:
180: l_approver_id := AP_WEB_AME_PKG.getProjectManagerID(l_project_id, nvl(l_week_end_date,trunc(sysdate)));