DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_RATE dependencies on BEN_PGM_F

Line 538: update ben_pgm_f

534: For i in c1 loop
535: --
536: If i.pgm_id is not null then
537: --
538: update ben_pgm_f
539: set drvbl_fctr_apls_rts_flag = 'Y'
540: where pgm_id = i.pgm_id;
541: --
542: end if;

Line 584: update ben_pgm_f

580: For i in c1 Loop
581: --
582: If i.pgm_id is not null then
583: --
584: update ben_pgm_f
585: set drvbl_fctr_apls_rts_flag = 'N'
586: where pgm_id = i.pgm_id
587: and drvbl_fctr_apls_rts_flag = 'Y'
588: and not exists (select null