DBA Data[Home] [Help]

APPS.PO_HEADERS_SV4 dependencies on FND_PROFILE

Line 448: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --

444: WHERE POH.po_header_id = p_po_header_id
445: AND POH.type_lookup_code = 'CONTRACT'
446: AND NVL(POH.cancel_flag, 'N') = 'N'
447: AND NVL(POH.closed_code, 'OPEN') = 'OPEN'
448: AND (( NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y' --
449: and poh.approved_date is not null )
450: OR POH.authorization_status = 'APPROVED' )
451: AND NVL(POH.frozen_flag, 'N') = 'N'
452: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.start_date), SYSDATE - 1)