DBA Data[Home] [Help]

APPS.SSP_SSPRPSMP_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 41: from per_all_people_f p1

37: (p_session_date between ppf.effective_start_date and ppf.effective_end_date)
38: or
39: (p_session_date > ppf.effective_end_date
40: and ppf.effective_end_date = (select max(p1.effective_end_date)
41: from per_all_people_f p1
42: where p1.person_id = ppf.person_id)
43: )
44: or
45: (p_session_date < ppf.effective_start_date