APPS.ZX_SRVC_TYP_PKG dependencies on DUAL

Line 2302: FROM DUAL

2298: fnd_global.user_id USER_ID_1,
2299: SYSDATE SYSTEM_DATE_2,
2300: fnd_global.user_id USER_ID_2,
2301: fnd_global.conc_login_id
2302: FROM DUAL
2303: WHERE NOT EXISTS (SELECT 'Y'
2304: FROM zx_errors_gt err_gt
2305: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
2306: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)

Line 8886: -- The invoice validation flow is then changed to processing individual invoices. At this point AP receives cursor already open error. To avoid this, adding this code to close and open the cursor for each call.

8882: RETURN;
8883: END IF;
8884:
8885: -- SDSU Bug 6605681, When AP is calling invoice validation in bulk process, it errors out with U1 violation in zx_lines_det_factors.
8886: -- The invoice validation flow is then changed to processing individual invoices. At this point AP receives cursor already open error. To avoid this, adding this code to close and open the cursor for each call.
8887: -- This is a temporary fix and tested. We need to identify where exactly they are receiving the cursor error and identify if cursor should be open or close. This fix will now go only in a one-off checkin, includable by AP
8888: -- Start Bug 6605681
8889: IF c_lines%ISOPEN THEN CLOSE c_lines;
8890: OPEN c_lines(p_event_class_rec);