[Home] [Help]
412: set (poo_party_id, poo_location_id) =
413: (select SR_PER.organization_id, -- poo_party_id
414: SR_HRL.location_id -- poo_location_id
415: from RA_CUSTOMER_TRX TRX,
416: JTF_RS_SALESREPS SR,
417: PER_ALL_ASSIGNMENTS_F SR_PER,
418: HR_ORGANIZATION_UNITS SR_HRL
419: where TRX.customer_trx_id = ZXL.trx_id
420: and TRX.primary_salesrep_id IS NOT NULL