342: BEGIN
343: x_cost_adj_ccid:=NULL;
344: SELECT gl_cost_adjustment_acct
345: INTO x_cost_adj_ccid
346: FROM ozf_supp_trd_prfls_all
347: WHERE supplier_id=p_vendor_id
348: AND supplier_site_id=p_vendor_site_id
349: AND org_id=p_org_id;
350: RETURN(x_cost_adj_ccid);
438: BEGIN
439: x_contra_liab_ccid:=NULL;
440: SELECT gl_contra_liability_acct
441: INTO x_contra_liab_ccid
442: FROM ozf_supp_trd_prfls_all
443: WHERE supplier_id=p_vendor_id
444: AND supplier_site_id=p_vendor_site_id
445: AND org_id=p_org_id;
446: return(x_contra_liab_ccid);