DBA Data[Home] [Help]

APPS.PA_PAXMGPBS_XMLP_PKG dependencies on PER_PEOPLE_F

Line 74: select full_name into member_name from per_people_f where

70: end if;
71: c_start_org := org_name;
72:
73: IF project_member is not null then
74: select full_name into member_name from per_people_f where
75: person_id = project_member
76: and sysdate between effective_start_date
77: and nvl(effective_end_date,sysdate + 1)
78: and (Current_NPW_Flag='Y' OR Current_Employee_Flag='Y')