DBA Data[Home] [Help]

APPS.PER_ASG_BUS3 dependencies on PO_VENDORS

Line 1045: FROM po_vendors pov

1041: l_api_updating BOOLEAN;
1042:
1043: CURSOR csr_chk_vendor_id IS
1044: SELECT pov.vendor_id
1045: FROM po_vendors pov
1046: WHERE pov.vendor_id = p_vendor_id
1047: AND p_effective_date BETWEEN
1048: NVL(pov.start_date_active, p_effective_date) AND
1049: NVL(pov.end_date_active, p_effective_date)