APPS.PA_RES_TYPES_PVT dependencies on PA_RES_TYPES_S
Line 24: select nvl(P_RES_TYPE_ID,PA_RES_TYPES_S.nextval)
20: cursor C is select ROWID from pa_res_types_b
21: where res_type_id = l_res_type_id;
22: begin
23: 24: select nvl(P_RES_TYPE_ID,PA_RES_TYPES_S.nextval) 25: into l_res_type_id
26: from dual;
27:
28: insert into pa_res_types_b (