APPS.AP_WEB_CUST_AME_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 133: from ap_expense_report_lines_all line

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: -----------------------------------------------------

Line 147: from ap_expense_report_lines_all line

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)));

Line 176: from ap_expense_report_lines_all line

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)));