DBA Data[Home] [Help]

APPS.PA_PAXPCIFS_XMLP_PKG dependencies on PER_PEOPLE_F

Line 63: select full_name into member_name from per_people_f where

59: end if;
60: c_start_org := org_name;
61:
62: IF project_member is not null then
63: select full_name into member_name from per_people_f where
64: person_id = project_member
65: and sysdate between effective_start_date
66: and nvl(effective_end_date,sysdate + 1)
67: and (Current_NPW_Flag='Y' OR Current_Employee_Flag='Y')