APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_PEOPLE_F

Line 328: p_person_id IN per_all_people_f.person_id%TYPE,

324: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
325: p_location_id IN per_all_assignments_f.location_id%TYPE,
326: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
327: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
328: p_person_id IN per_all_people_f.person_id%TYPE,
329: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
330: )
331: RETURN VARCHAR2
332: IS

Line 373: from per_all_people_f peo

369: l_where_clause :=
370: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
371: [DETAIL_BLOCK.RESOURCE_ID]
372: {in (select peo.person_id
373: from per_all_people_f peo
374: where peo.business_group_id = '
375: || p_bg_id
376: || ')}';
377: ELSIF p_gre_id IS NULL