APPS.HXC_APPROVAL_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 227: from per_assignments_f

223: l_person_name := null;
224:
225: if ( p_person_id is not null) then
226: select supervisor_id into l_supervisor_id
227: from per_assignments_f
228: where person_id = p_person_id;
229:
230: if (l_supervisor_id is not null) then
231:

Line 265: from per_assignments_f

261: l_organization_id := null;
262:
263: if ( p_person_id is not null) then
264: select organization_id into l_organization_id
265: from per_assignments_f
266: where person_id = p_person_id;
267:
268: if (l_organization_id is not null) then
269: select name into l_organization_name

Line 301: from per_assignments_f

297: l_flex_id := null;
298:
299: if ( p_person_id is not null) then
300: select soft_coding_keyflex_id into l_flex_id
301: from per_assignments_f
302: where person_id = p_person_id;
303:
304: if (l_flex_id is not null) then
305: select CONCATENATED_SEGMENTS into l_cost_center

Line 327: from per_assignments_f

323: l_payroll_id := null;
324:
325: if ( p_person_id is not null) then
326: select payroll_id into l_payroll_id
327: from per_assignments_f
328: where person_id = p_person_id;
329:
330: if (l_payroll_id is not null) then
331: select payroll_name into l_payroll_name