APPS.PO_VAL_HEADERS dependencies on FND_PROFILE

Line 1325: AND TRUNC(p_end_date_tbl(i)+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)) < TRUNC(ORDER_HEADER.approved_date)

1321: -- Bug # 13550798 Changed logic based on approved_date
1322: --AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)
1323: AND ORDER_HEADER.po_header_id = ORDER_LINE.po_header_id
1324: AND ORDER_HEADER.approved_date IS NOT NULL
1325: AND TRUNC(p_end_date_tbl(i)+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)) < TRUNC(ORDER_HEADER.approved_date)
1326: AND NVL(ORDER_HEADER.closed_code,'X') <> c_FINALLY_CLOSED
1327: AND NVL(ORDER_HEADER.cancel_flag,'N') <> 'Y'
1328: )
1329: ;

Line 1493: AND TRUNC(p_end_date_tbl(i)+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)) < TRUNC(ORDER_HEADER.approved_date)

1489: -- Bug # 13550798 Changed logic based on approved_date
1490: -- AND p_end_date_tbl(i) < TRUNC(ORDER_LINE.creation_date)
1491: AND ORDER_HEADER.po_header_id = ORDER_LINE.po_header_id
1492: AND ORDER_HEADER.approved_date IS NOT NULL
1493: AND TRUNC(p_end_date_tbl(i)+ nvl(FND_PROFILE.VALUE('PO_REL_CREATE_TOLERANCE'),0)) < TRUNC(ORDER_HEADER.approved_date)
1494: AND NVL(ORDER_HEADER.closed_code,'X') <> c_FINALLY_CLOSED
1495: AND NVL(ORDER_HEADER.cancel_flag,'N') <> 'Y'
1496: )
1497: ;

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

2819: AND NVL(POH.cancel_flag, 'N') = 'N'
2820: AND NVL(POH.frozen_flag,'N') = 'N'
2821: AND NVL(POH.user_hold_flag, 'N') = 'N'
2822: AND ((POH.type_lookup_code = 'CONTRACT'
2823: AND NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
2824: AND POH.approved_date is not null)
2825: OR
2826: POH.authorization_status = 'APPROVED'
2827: )