APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_CRIT_VAL

Line 491: FROM ben_ext_crit_val

487: );
488:
489: CURSOR c_ext_crit_val(p_ext_crit_typ_id IN NUMBER) IS
490: SELECT *
491: FROM ben_ext_crit_val
492: WHERE ext_crit_typ_id = p_ext_crit_typ_id
493: AND ((business_group_id IS NULL AND legislation_code IS NULL)
494: OR (legislation_code IS NOT NULL
495: AND legislation_code = p_legislation_code)

Line 523: l_new_val_1 ben_ext_crit_val.val_1%type ;

519: l_new_ext_crit_prfl_id NUMBER(15);
520: l_new_ext_crit_typ_id NUMBER(15);
521: l_new_ext_crit_val_id NUMBER(15);
522: l_new_ext_crit_cmbn_id NUMBER(15);
523: l_new_val_1 ben_ext_crit_val.val_1%type ;
524:
525:
526: l_new_object_version_number NUMBER(9);
527: l_proc VARCHAR2(72) := g_package||'copy_criteria_definition';

Line 617: -- Insert into BEN_EXT_CRIT_VAL using Row Handler

613: ELSE
614: l_new_val_1 := r_curr_ext_crit_val.val_1;
615: END IF; -- r_curr_ext_crit_typ.crit_typ_cd = 'PRL'
616:
617: -- Insert into BEN_EXT_CRIT_VAL using Row Handler
618: ben_xcv_ins.ins
619: (
620: p_effective_date => p_effective_date
621: ,p_ext_crit_val_id => l_new_ext_crit_val_id -- OUT