Hi using cursor, i need to fetch the end date from fnd_user table and update it in XXDEV_CU165_HR_APPR_LIMITS table.How to achieve this.
PROCEDURE XX_PROC IS
CURSOR CUR_INACTIVE_USER IS
SELECT fu.user_id,fu.end_date
FROM fnd_user fu, cu165_hr_appr_limits hral,
where fu.employee_id =hral.person_id
AND fu.end_date IS NOT NULL;
BEGIN
FOR rec_inactive_user IN cur_inactive_user LOOP
UPDATE XXDEV\_CU165\_HR\_APPR\_LIMITS HRAL
SET HRAL.END_DATE_ACTIVE = (
SELECT FU.END_DATE
FROM FND_USER FU
WHERE FU.EMPLOYEE_ID = HRAL.PERSON_ID
)
WHERE EXISTS(
SELECT 1
FROM FND_USER FU
WHERE FU.EMPLOYEE_ID = HRAL.PERSON_ID
AND FU.END_DATE IS NOT NULL
)
AND (
HRAL.END_DATE_ACTIVE IS NULL
OR
HRAL.END_DATE_ACTIVE > sysdate
);
END LOOP;
COMMIT;
END XX_PROC;