APPS.BEN_EXT_CHLG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6159: l_old_organization hr_all_organization_units.name%type;

6155: l_old_status hr_lookups.meaning%type;
6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;
6158: l_new_incident per_work_incidents.incident_reference%type;
6159: l_old_organization hr_all_organization_units.name%type;
6160: l_new_organization hr_all_organization_units.name%type;
6161:
6162: --
6163: begin

Line 6160: l_new_organization hr_all_organization_units.name%type;

6156: l_new_status hr_lookups.meaning%type;
6157: l_old_incident per_work_incidents.incident_reference%type;
6158: l_new_incident per_work_incidents.incident_reference%type;
6159: l_old_organization hr_all_organization_units.name%type;
6160: l_new_organization hr_all_organization_units.name%type;
6161:
6162: --
6163: begin
6164: --

Line 6205: from hr_all_organization_units

6201:
6202: if nvl(p_old_rec.organization_id,1) <> nvl(p_new_rec.organization_id,1) then
6203:
6204: select name into l_old_organization
6205: from hr_all_organization_units
6206: where organization_id = p_old_rec.organization_id ;
6207:
6208: select name into l_new_organization
6209: from hr_all_organization_units

Line 6209: from hr_all_organization_units

6205: from hr_all_organization_units
6206: where organization_id = p_old_rec.organization_id ;
6207:
6208: select name into l_new_organization
6209: from hr_all_organization_units
6210: where organization_id = p_new_rec.organization_id ;
6211:
6212: l_tab_counter := l_tab_counter + 1;
6213: l_chg_evt_tab(l_tab_counter) := 'CORGID';