APPS.BEN_EXT_CHLG dependencies on PER_WORK_INCIDENTS

Line 6253: l_old_incident per_work_incidents.incident_reference%type;

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

Line 6254: l_new_incident per_work_incidents.incident_reference%type;

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

Line 6268: from per_work_incidents

6264:
6265: if nvl(p_old_rec.incident_id,1) <> nvl(p_new_rec.incident_id,1) then
6266:
6267: select incident_reference into l_old_incident
6268: from per_work_incidents
6269: where incident_id = p_old_rec.incident_id ;
6270:
6271: select incident_reference into l_new_incident
6272: from per_work_incidents

Line 6272: from per_work_incidents

6268: from per_work_incidents
6269: where incident_id = p_old_rec.incident_id ;
6270:
6271: select incident_reference into l_new_incident
6272: from per_work_incidents
6273: where incident_id = l_new_incident ;
6274:
6275: l_tab_counter := l_tab_counter + 1;
6276: l_chg_evt_tab(l_tab_counter) := 'CINCID';