282:
283: IF ( pn_org_id = ln_source_org_id) THEN -- 'Distribution Out'
284: SELECT DISTINCT ja.meaning
285: INTO lv_des_org_type
286: FROM ja_lookups ja,
287: jai_rgm_dis_des_hdrs jrddh,
288: jai_rgm_dis_src_taxes jrdst,
289: jai_rgm_dis_des_taxes jrddt
290:
300: RETURN(lv_des_org_type);
301: ELSE -- 'Distribution In'
302: SELECT DISTINCT ja.meaning
303: INTO lv_des_org_type
304: FROM ja_lookups ja,
305: jai_rgm_dis_des_hdrs jrddh,
306: jai_rgm_dis_src_taxes jrdst,
307: jai_rgm_dis_des_taxes jrddt
308: