[Home] [Help]
34: PROCEDURE update_pcd_sent_dt(p_per_cm_prvdd_id in number
35: ,p_effective_Date in date ) IS
36: PRAGMA AUTONOMOUS_TRANSACTION;
37: BEGIN
38: update ben_per_cm_prvdd_f
39: set sent_Dt = p_effective_Date
40: where per_cm_prvdd_id = p_per_cm_prvdd_id
41: and sent_dt is null
42: and p_effective_Date between