APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXP_REPORT_DISTS

Line 2019: FROM AP_EXP_REPORT_DISTS

2015: WHERE parameter_id = p_parameter_id;
2016:
2017: CURSOR distribution_c(p_report_line_id IN NUMBER) IS
2018: SELECT REPORT_HEADER_ID
2019: FROM AP_EXP_REPORT_DISTS
2020: WHERE (REPORT_LINE_ID = p_report_line_id)
2021: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
2022:
2023: rounding_line_rec rounding_line_c%ROWTYPE;

Line 2151: DELETE AP_EXP_REPORT_DISTS_ALL

2147:
2148: OPEN distribution_c(rounding_line_rec.report_line_id);
2149: FETCH distribution_c into distribution_rec;
2150: IF distribution_c%FOUND THEN
2151: DELETE AP_EXP_REPORT_DISTS_ALL
2152: WHERE CURRENT OF distribution_c;
2153: END IF;
2154: CLOSE distribution_c;
2155: