APPS.AP_APPROVAL_MATCHED_PKG dependencies on DUAL

Line 3377: FROM sys.dual

3373: p_calling_sequence;
3374:
3375: SELECT 'Y'
3376: INTO l_holds_exist
3377: FROM sys.dual
3378: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3379: FROM ap_holds AH
3380: WHERE AH.invoice_id = p_invoice_id
3381: AND AH.hold_lookup_code NOT IN (p_hold_code, p_hold_code2)

Line 3429: FROM sys.dual

3425: p_calling_sequence;
3426:
3427: SELECT 'Y'
3428: INTO l_holds_exist
3429: FROM sys.dual
3430: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3431: FROM ap_holds AH
3432: WHERE AH.invoice_id = p_invoice_id
3433: AND AH.hold_lookup_code IN (p_hold_code, p_hold_code2)