DBA Data[Home] [Help]

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