APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXP_REPORT_DISTS

Line 1902: FROM AP_EXP_REPORT_DISTS

1898: WHERE parameter_id = p_parameter_id;
1899:
1900: CURSOR distribution_c(p_report_line_id IN NUMBER) IS
1901: SELECT REPORT_HEADER_ID
1902: FROM AP_EXP_REPORT_DISTS
1903: WHERE (REPORT_LINE_ID = p_report_line_id)
1904: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
1905:
1906: rounding_line_rec rounding_line_c%ROWTYPE;

Line 2034: DELETE AP_EXP_REPORT_DISTS_ALL

2030:
2031: OPEN distribution_c(rounding_line_rec.report_line_id);
2032: FETCH distribution_c into distribution_rec;
2033: IF distribution_c%FOUND THEN
2034: DELETE AP_EXP_REPORT_DISTS_ALL
2035: WHERE CURRENT OF distribution_c;
2036: END IF;
2037: CLOSE distribution_c;
2038: