APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 113: from per_all_people_f

109: l_effective_end_date DATE DEFAULT NULL;
110: --
111: cursor c1(param_person_id NUMBER) is
112: select full_name,effective_start_date,effective_end_date
113: from per_all_people_f
114: where person_id = param_person_id
115: order by effective_start_date desc;
116: --
117: begin

Line 1208: from per_all_people_f

1204: select --employee_number,
1205: full_name,
1206: --, work_telephone, email_address,
1207: effective_start_date,effective_end_date
1208: from per_all_people_f
1209: where person_id = param_party_contact_id
1210: order by effective_start_date desc;
1211:
1212: cursor c_party is

Line 1401: from per_all_people_f

1397: l_effective_end_date DATE DEFAULT NULL;
1398: --
1399: cursor c1(param_person_id NUMBER) is
1400: select full_name,effective_start_date,effective_end_date
1401: from per_all_people_f
1402: where person_id = param_person_id
1403: order by effective_start_date desc;
1404: --
1405: begin