APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_PEOPLE_F

Line 424: p_person_id IN per_all_people_f.person_id%TYPE,

420: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
421: p_location_id IN per_all_assignments_f.location_id%TYPE,
422: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
423: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
424: p_person_id IN per_all_people_f.person_id%TYPE,
425: p_gre_id IN hr_soft_coding_keyflex.segment1%TYPE
426: )
427: RETURN VARCHAR2
428: IS

Line 469: from per_all_people_f peo

465: l_where_clause :=
466: '[DETAIL_BLOCK.RESOURCE_TYPE] {=''PERSON'' AND}
467: [DETAIL_BLOCK.RESOURCE_ID]
468: {in (select peo.person_id
469: from per_all_people_f peo
470: where peo.business_group_id = '
471: || p_bg_id
472: || ')}';
473: ELSIF p_gre_id IS NULL