APPS.CLN_UPDTDLVY_PKG dependencies on PER_PEOPLE_F

Line 453: FROM per_people_f p, org_organization_definitions o, rcv_shipment_headers h

449: end if;
450:
451: SELECT o.organization_id
452: INTO l_org_id
453: FROM per_people_f p, org_organization_definitions o, rcv_shipment_headers h
454: WHERE nvl(h.shipped_date, h.last_update_date)
455: BETWEEN NVL(p.effective_start_date, NVL(h.shipped_date, h.last_update_date))
456: AND NVL(p.effective_end_date, NVL(h.shipped_date, h.last_update_date))
457: AND p.person_id (+) = h.employee_id