DBA Data[Home] [Help]

APPS.PAY_ISB_BUS dependencies on PER_WORK_INCIDENTS

Line 106: procedure chk_incident_id( p_incident_id in per_work_incidents.incident_id%type) is

102: --
103: -- ----------------------------------------------------------------------------
104: -- |---------------------------< chk_incident_id >---------------------------|
105: -- ----------------------------------------------------------------------------
106: procedure chk_incident_id( p_incident_id in per_work_incidents.incident_id%type) is
107: cursor c_incident_id is
108: select incident_id
109: from per_work_incidents
110: where incident_id = p_incident_id;

Line 109: from per_work_incidents

105: -- ----------------------------------------------------------------------------
106: procedure chk_incident_id( p_incident_id in per_work_incidents.incident_id%type) is
107: cursor c_incident_id is
108: select incident_id
109: from per_work_incidents
110: where incident_id = p_incident_id;
111: l_incident_id integer;
112: begin
113: open c_incident_id;