DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on DUAL

Line 3820: FROM sys.dual

3816: p_calling_sequence;
3817:
3818: SELECT 'Y'
3819: INTO l_holds_exist
3820: FROM sys.dual
3821: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3822: FROM ap_holds AH
3823: WHERE AH.invoice_id = p_invoice_id
3824: AND AH.hold_lookup_code NOT IN (p_hold_code, p_hold_code2)

Line 3872: FROM sys.dual

3868: p_calling_sequence;
3869:
3870: SELECT 'Y'
3871: INTO l_holds_exist
3872: FROM sys.dual
3873: WHERE EXISTS (SELECT DISTINCT 'Invoice has unreleased holds'
3874: FROM ap_holds AH
3875: WHERE AH.invoice_id = p_invoice_id
3876: AND AH.hold_lookup_code IN (p_hold_code, p_hold_code2)