APPS.HR_H2PI_ERROR dependencies on HR_ALL_ORGANIZATION_UNITS

Line 125: l_org_name hr_all_organization_units.name%type;

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;
126: l_context hr_organization_information.org_information_context%type;
127: l_org_classification hr_organization_information.org_information1%type;
128: l_element_name pay_element_types_f.element_name%type;
129: TYPE ErrorRecTable is TABLE of hr_h2pi_message_lines%ROWTYPE

Line 376: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'

372: WHERE ogc.org_information_id = csr_rec.from_id
373: --AND ogc.business_group_id = l_from_business_group_id
374: AND ogc.client_id = l_from_client_id
375: AND ogc.organization_id = map.from_id
376: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'
377: AND ogs.business_group_id = csr_rec.to_business_group_id
378: AND map.to_id = ogs.organization_id
379: AND rownum < 2;
380:

Line 403: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'

399: WHERE org_information_id = csr_rec.from_id
400: --AND ogi.business_group_id = l_from_business_group_id
401: AND ogi.client_id = l_from_client_id
402: AND ogi.organization_id = map.from_id
403: AND map.table_name = 'HR_ALL_ORGANIZATION_UNITS'
404: AND ogs.business_group_id = csr_rec.to_business_group_id
405: AND map.to_id = ogs.organization_id
406: AND rownum < 2;
407: