[Home] [Help]
10: FULL_NAME
11: INTO
12: C_PERSON_NAME
13: FROM
14: PER_ALL_PEOPLE_F
15: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
16: AND PERSON_ID = P_PERSON_ID
17: AND C_EFFECTIVE_DATE between EFFECTIVE_START_DATE
18: AND EFFECTIVE_END_DATE;