DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 1035: from PER_BUSINESS_GROUPS_PERF pb,

1031: value VARCHAR2(1000) := '';
1032: begin
1033: select distinct pb.name
1034: into value
1035: from PER_BUSINESS_GROUPS_PERF pb,
1036: per_all_people_f hre
1037: where hre.person_id = approver_id
1038: and hre.business_group_id=pb.business_group_id
1039: and trunc(sysdate) BETWEEN effective_start_date