APPS.ZX_SRVC_TYP_PKG dependencies on DUAL

Line 2355: FROM DUAL

2351: fnd_global.user_id USER_ID_1,
2352: SYSDATE SYSTEM_DATE_2,
2353: fnd_global.user_id USER_ID_2,
2354: fnd_global.conc_login_id
2355: FROM DUAL
2356: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2357: AND NOT EXISTS (SELECT 'Y'
2358: FROM zx_errors_gt err_gt
2359: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)

Line 2952: FROM DUAL

2948: fnd_global.user_id USER_ID_1,
2949: SYSDATE SYSTEM_DATE_2,
2950: fnd_global.user_id USER_ID_2,
2951: fnd_global.conc_login_id
2952: FROM DUAL
2953: WHERE p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IS NOT NULL
2954: AND p_trx_line_dist_tbl.LINE_LEVEL_ACTION(i) IN
2955: ('CREATE',
2956: 'CREATE_TAX_ONLY',

Line 9798: -- 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.

9794: RETURN;
9795: END IF;
9796:
9797: -- SDSU Bug 6605681, When AP is calling invoice validation in bulk process, it errors out with U1 violation in zx_lines_det_factors.
9798: -- 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.
9799: -- 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
9800: -- Start Bug 6605681
9801: IF c_lines%ISOPEN THEN CLOSE c_lines;
9802: OPEN c_lines(p_event_class_rec);