1148: --
1149: -- Cursor to determine resp_id
1150: CURSOR csr_get_resp_id(l_app_id IN number, l_resp_name IN varchar2) IS
1151: SELECT responsibility_id
1152: FROM fnd_responsibility_vl
1153: WHERE application_id = l_app_id
1154: AND responsibility_name = l_resp_name;
1155: --
1156: BEGIN
1258: WHERE upper(application_short_name) = upper(p_resp_application);
1259: --
1260: CURSOR csr_chk_resp_exists(l_app_id IN number, l_resp_name IN varchar2) IS
1261: SELECT responsibility_id
1262: FROM fnd_responsibility_vl
1263: WHERE application_id = l_app_id
1264: AND responsibility_name = l_resp_name;
1265: --
1266: BEGIN