2659: AND Nvl(poh.cancel_flag, 'N') = 'N'
2660: AND Nvl(poh.frozen_flag, 'N') = 'N'
2661: AND Nvl(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED' )
2662: OR ( poh.type_lookup_code = 'CONTRACT'
2663: AND ( ( Nvl(fnd_profile.Value(
2664: 'ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),
2665: 'N') =
2666: 'Y'
2667: AND poh.approved_date IS NOT NULL )
2761: AND Nvl(poh.cancel_flag, 'N') = 'N'
2762: AND Nvl(poh.frozen_flag, 'N') = 'N'
2763: AND Nvl(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED' )
2764: OR ( poh.type_lookup_code = 'CONTRACT'
2765: AND ( ( Nvl(fnd_profile.Value(
2766: 'ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),
2767: 'N') =
2768: 'Y'
2769: AND poh.approved_date IS NOT NULL )