DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_VENDORS

Line 1696: FROM po_vendors pov

1692: IF p_change_type_tbl(i) = 'VENDOR' THEN
1693: BEGIN
1694: SELECT 'Y'
1695: INTO l_hold_exists
1696: FROM po_vendors pov
1697: ,po_system_parameters psp
1698: WHERE pov.vendor_id = p_new_vendor_id_tbl(i)
1699: AND NVL(psp.enforce_vendor_hold_flag,'N') = 'Y'
1700: AND NVL(pov.hold_flag,'N') = 'Y';