APPS.POR_VIEW_REQS_PKG dependencies on PER_BUSINESS_GROUPS_PERF
Line 957: from PER_BUSINESS_GROUPS_PERF pb,
953: value VARCHAR2(1000) := '';
954: begin
955: select distinct pb.name
956: into value 957: from PER_BUSINESS_GROUPS_PERF pb, 958: per_all_people_f hre
959: where hre.person_id = approver_id
960: and hre.business_group_id=pb.business_group_id
961: and trunc(sysdate) BETWEEN effective_start_date