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