[Home] [Help]
856: vParams varchar2(2000);
857:
858: CURSOR cFndResp (pRespId in varchar2) is
859: select application_id
860: from fnd_responsibility
861: where responsibility_id=pRespId;
862:
863: begin
864: l_user_id := pUserId;
877:
878: /*
879: begin
880: select application_id into l_application_id
881: from fnd_responsibility
882: where responsibility_id=l_fn_responsibility_id;
883: end;
884:
885: if pRequestType <> 'R' then