APPS.PA_PAXINGEN_XMLP_PKG dependencies on PER_PEOPLE_F
Line 116: per_people_f where
112: IF project_member is not null then
113: begin
114:
115: select substr(full_name, 1, 40) into member_name from 116: per_people_f where 117: person_id = project_member
118: and sysdate between effective_start_date
119: and nvl(effective_end_date,sysdate + 1)
120: and (Current_NPW_Flag='Y' OR Current_Employee_Flag='Y')