DBA Data[Home] [Help]

APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_CRIT_PRFL

Line 468: FROM ben_ext_crit_prfl

464: ) IS
465:
466: CURSOR c_ext_crit_prfl IS
467: SELECT *
468: FROM ben_ext_crit_prfl
469: WHERE ext_crit_prfl_id = p_ext_crit_prfl_id
470: AND ((business_group_id IS NULL AND legislation_code IS NULL)
471: OR (legislation_code IS NOT NULL
472: AND legislation_code = p_legislation_code)

Line 536: -- Insert into BEN_EXT_CRIT_PRFL using Row Handler

532:
533: FOR r_curr_ext_crit_prfl IN c_ext_crit_prfl
534: LOOP -- 2 Get Criteria Profile data for current EXT_DFN_ID
535:
536: -- Insert into BEN_EXT_CRIT_PRFL using Row Handler
537: ben_xcr_ins.ins
538: (
539: p_ext_crit_prfl_id => l_new_ext_crit_prfl_id -- OUT
540: ,p_name => fix_name_length