DECLARE
l_user_id NUMBER;
CURSOR cur_rec
IS
SELECT * FROM fnd_responsibility_vl
WHERE UPPER (responsibility_name) = UPPER ('AE HRMS Manager');
BEGIN
SELECT user_id INTO l_user_id FROM fnd_user
WHERE user_name like '%ROHIDAS%123';
FOR rec_cur IN cur_rec
LOOP
fnd_user_resp_groups_api.insert_assignment (
user_id => l_user_id,
responsibility_id => rec_cur.responsibility_id,
responsibility_application_id => rec_cur.application_id,
security_group_id => 0,
start_date => SYSDATE - 1,
end_date => NULL,
description => NULL
);
COMMIT;
END LOOP;
END;
------------------------------------------------------------------------------------------------------------
Hello Sir,please put a blog on how to use the following queries:-
ReplyDelete1>creating view,
2>using join,
3>retrieving data from two database tables.
please Sir.
Thank-you.
amlya salya sir bir mhanu nakos...tuza query pathwto dupar paryant...........
ReplyDelete