DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on PER_ALL_PEOPLE_F

Line 121: l_person_name per_all_people_f.full_name%type;

117: -- ----------------------------------------------------------------------------
118: --
119: PROCEDURE generate_error_report IS
120:
121: l_person_name per_all_people_f.full_name%type;
122: l_location_name hr_locations_all.location_code%type;
123: l_assignment_number per_all_assignments_f.assignment_number%type;
124: l_pay_method_name pay_org_payment_methods_f.org_payment_method_name%type;
125: l_org_name hr_all_organization_units.name%type;

Line 451: AND map.table_name = 'PER_ALL_PEOPLE_F'

447: --AND ad.business_group_id = l_from_business_group_id
448: AND ad.client_id = l_from_client_id
449: AND em.business_group_id = csr_rec.to_business_group_id
450: AND ad.person_id = map.from_id
451: AND map.table_name = 'PER_ALL_PEOPLE_F'
452: AND map.to_id = em.person_id
453: AND rownum < 2;
454:
455: l_text := 'Person Name: ' || l_person_name || ' - ' || l_text ;