APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_INCL_CHG

Line 724: SELECT * from ben_ext_incl_chg

720: AND business_group_id = p_business_group_id)
721: );
722:
723: CURSOR c_RinF_incl_chg(p_ext_rcd_in_file_id IN NUMBER) IS
724: SELECT * from ben_ext_incl_chg
725: WHERE ext_rcd_in_file_id = p_ext_rcd_in_file_id
726: AND ((business_group_id IS NULL AND legislation_code IS NULL)
727: OR (legislation_code IS NOT NULL
728: AND legislation_code = p_legislation_code)

Line 791: SELECT * from ben_ext_incl_chg

787: AND business_group_id = p_business_group_id)
788: );
789:
790: CURSOR c_DinR_incl_chg(p_ext_data_elmt_in_rcd_id IN NUMBER) IS
791: SELECT * from ben_ext_incl_chg
792: WHERE ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
793: AND ((business_group_id IS NULL AND legislation_code IS NULL)
794: OR (legislation_code IS NOT NULL
795: AND legislation_code = p_legislation_code)

Line 1209: -- Insert into BEN_EXT_INCL_CHG using Row Handler

1205:
1206: FOR r_curr_DinR_incl_chg IN c_DinR_incl_chg(r_curr_data_elmt_in_rcd.ext_data_elmt_in_rcd_id)
1207: LOOP -- 16 Get Inclusion on Change Event data for current EXT_DATA_ELMT_IN_RCD_ID
1208:
1209: -- Insert into BEN_EXT_INCL_CHG using Row Handler
1210: ben_xic_ins.ins
1211: (
1212: p_ext_incl_chg_id => l_new_DinR_incl_chg_id -- OUT
1213: ,p_chg_evt_cd => r_curr_DinR_incl_chg.chg_evt_cd

Line 1298: -- Insert into BEN_EXT_INCL_CHG using Row Handler

1294:
1295: FOR r_curr_RinF_incl_chg IN c_RinF_incl_chg(r_curr_ext_rcd_in_file.ext_rcd_in_file_id)
1296: LOOP -- 15 Get Inclusion on Change Event data for current EXT_RCD_IN_FILE_ID
1297:
1298: -- Insert into BEN_EXT_INCL_CHG using Row Handler
1299: ben_xic_ins.ins
1300: (
1301: p_ext_incl_chg_id => l_new_RinF_incl_chg_id -- OUT
1302: ,p_chg_evt_cd => r_curr_RinF_incl_chg.chg_evt_cd