DBA Data[Home] [Help]

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')