APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_CRIT_CMBN

Line 502: FROM ben_ext_crit_cmbn

498: );
499:
500: CURSOR c_ext_crit_cmbn(p_ext_crit_val_id IN NUMBER) IS
501: SELECT *
502: FROM ben_ext_crit_cmbn
503: WHERE ext_crit_val_id = p_ext_crit_val_id
504: AND ((business_group_id IS NULL AND legislation_code IS NULL)
505: OR (legislation_code IS NOT NULL
506: AND legislation_code = p_legislation_code)

Line 634: -- Insert into BEN_EXT_CRIT_CMBN using Row Handler

630:
631: FOR r_curr_ext_crit_cmbn IN c_ext_crit_cmbn(r_curr_ext_crit_val.ext_crit_val_id)
632: LOOP -- 5 Get Criteria Combination data for current EXT_CRIT_VAL_ID
633:
634: -- Insert into BEN_EXT_CRIT_CMBN using Row Handler
635: ben_xcc_ins.ins
636: (
637: p_ext_crit_cmbn_id => l_new_ext_crit_cmbn_id -- OUT
638: ,p_crit_typ_cd => r_curr_ext_crit_cmbn.crit_typ_cd