546: For i in c1 loop
547: --
548: If i.pgm_id is not null then
549: -- 550: update ben_pgm_f 551: set drvbl_fctr_apls_rts_flag = 'Y'
552: where pgm_id = i.pgm_id;
553: --
554: end if;
Line 596: update ben_pgm_f
592: For i in c1 Loop
593: --
594: If i.pgm_id is not null then
595: -- 596: update ben_pgm_f 597: set drvbl_fctr_apls_rts_flag = 'N'
598: where pgm_id = i.pgm_id
599: and drvbl_fctr_apls_rts_flag = 'Y'
600: and not exists (select null