APPS.BEN_EXT_CHLG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6255: l_old_organization hr_all_organization_units.name%type;

6251: l_old_status hr_lookups.meaning%type;
6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;
6254: l_new_incident per_work_incidents.incident_reference%type;
6255: l_old_organization hr_all_organization_units.name%type;
6256: l_new_organization hr_all_organization_units.name%type;
6257:
6258: --
6259: begin

Line 6256: l_new_organization hr_all_organization_units.name%type;

6252: l_new_status hr_lookups.meaning%type;
6253: l_old_incident per_work_incidents.incident_reference%type;
6254: l_new_incident per_work_incidents.incident_reference%type;
6255: l_old_organization hr_all_organization_units.name%type;
6256: l_new_organization hr_all_organization_units.name%type;
6257:
6258: --
6259: begin
6260: --

Line 6301: from hr_all_organization_units

6297:
6298: if nvl(p_old_rec.organization_id,1) <> nvl(p_new_rec.organization_id,1) then
6299:
6300: select name into l_old_organization
6301: from hr_all_organization_units
6302: where organization_id = p_old_rec.organization_id ;
6303:
6304: select name into l_new_organization
6305: from hr_all_organization_units

Line 6305: from hr_all_organization_units

6301: from hr_all_organization_units
6302: where organization_id = p_old_rec.organization_id ;
6303:
6304: select name into l_new_organization
6305: from hr_all_organization_units
6306: where organization_id = p_new_rec.organization_id ;
6307:
6308: l_tab_counter := l_tab_counter + 1;
6309: l_chg_evt_tab(l_tab_counter) := 'CORGID';