APPS.PER_PER_BUS dependencies on PO_VENDORS

Line 6774: -- Cursor to validate vendor_id in PO_VENDORS table.

6770: l_proc varchar2(72);
6771: l_api_updating boolean;
6772: l_exists varchar2(1);
6773: --
6774: -- Cursor to validate vendor_id in PO_VENDORS table.
6775: --
6776: cursor csr_chk_vendor is
6777: select null
6778: from po_vendors

Line 6778: from po_vendors

6774: -- Cursor to validate vendor_id in PO_VENDORS table.
6775: --
6776: cursor csr_chk_vendor is
6777: select null
6778: from po_vendors
6779: where vendor_id = p_vendor_id;
6780: --
6781: begin
6782: if g_debug then

Line 6812: -- in the PO_VENDORS table.

6808: if return_system_person_type(p_person_type_id,p_business_group_id)
6809: in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') then
6810: --
6811: -- Vendor id can be null, but if it is not null then it must exist
6812: -- in the PO_VENDORS table.
6813: --
6814: if p_vendor_id is not null then
6815: if g_debug then
6816: hr_utility.set_location(l_proc, 40);