DBA Data[Home] [Help]

APPS.SSP_SSPRPSMP_XMLP_PKG dependencies on PER_PEOPLE_F

Line 33: from per_people_f ppf

29: end if;
30:
31: if P_person_id is not null then
32: Select distinct substr(full_name,1,80) into C_person_name
33: from per_people_f ppf
34: where person_id = P_person_id
35: and business_group_id = P_business_group_id
36: and (
37: (p_session_date between ppf.effective_start_date and ppf.effective_end_date)