APPS.BEN_EXT_CHLG dependencies on PER_WORK_INCIDENTS

Line 6157: l_old_incident per_work_incidents.incident_reference%type;

6153: l_old_reason hr_lookups.meaning%type;
6154: l_new_reason hr_lookups.meaning%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:

Line 6158: l_new_incident per_work_incidents.incident_reference%type;

6154: l_new_reason hr_lookups.meaning%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: --

Line 6172: from per_work_incidents

6168:
6169: if nvl(p_old_rec.incident_id,1) <> nvl(p_new_rec.incident_id,1) then
6170:
6171: select incident_reference into l_old_incident
6172: from per_work_incidents
6173: where incident_id = p_old_rec.incident_id ;
6174:
6175: select incident_reference into l_new_incident
6176: from per_work_incidents

Line 6176: from per_work_incidents

6172: from per_work_incidents
6173: where incident_id = p_old_rec.incident_id ;
6174:
6175: select incident_reference into l_new_incident
6176: from per_work_incidents
6177: where incident_id = l_new_incident ;
6178:
6179: l_tab_counter := l_tab_counter + 1;
6180: l_chg_evt_tab(l_tab_counter) := 'CINCID';