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 1207: from per_all_people_f

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

Line 1400: from per_all_people_f

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