APPS.BIV_RT_TASK_BLOG_PKG dependencies on HZ_PARTIES

Line 585: set col8 = (select substr(party_name,1,50) from hz_parties p

581: end;
582: l_pos := 'updating party name';
583: begin
584: update biv_tmp_hs2 r
585: set col8 = (select substr(party_name,1,50) from hz_parties p
586: where p.party_id = r.col7)
587: where report_code = 'BIV_SERVICE_REQUEST'
588: and session_id = l_session_id;
589: exception