APPS.PSP_PSPRCLSL_XMLP_PKG dependencies on PER_PEOPLE_F
Line 40: from per_people_f
36: from per_time_periods
37: where time_period_id = p_time_period_id;
38:
39: select full_name into x_person_name 40: from per_people_f 41: where person_id = person_id_1
42: and x_end_date BETWEEN effective_start_date and effective_end_date;
43:
44: return(x_person_name);