APPS.CLN_UPDTDLVY_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 100: FROM rcv_shipment_headers h

96:
97: -- logic to get parameters.
98: SELECT h.vendor_id, h.vendor_site_id
99: INTO party_id, party_site_id
100: FROM rcv_shipment_headers h
101: WHERE h.shipment_header_id = p_shipment_header_id;
102:
103: select FND_PROFILE.VALUE('ORG_ID')
104: into l_organization_id

Line 150: SELECT h.receipt_num INTO l_receipt_id FROM rcv_shipment_headers h

146: if (l_debug_level <= 1) then
147: cln_debug_pub.Add('Failure point ' || x_progress, 1);
148: end if;
149:
150: SELECT h.receipt_num INTO l_receipt_id FROM rcv_shipment_headers h
151: WHERE h.shipment_header_id = p_shipment_header_id;
152:
153: l_ref_num := l_receipt_id || '-' || sys_guid();
154:

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