APPS.BEN_COPY_EXTRACT dependencies on BEN_EXT_RCD_IN_FILE

Line 250: FROM ben_ext_rcd_in_file

246: CURSOR c_new_data_elmt_in_rcd_id IS
247: SELECT ext_data_elmt_in_rcd_id
248: FROM ben_ext_data_elmt_in_rcd
249: WHERE ext_rcd_id = (SELECT ext_rcd_id
250: FROM ben_ext_rcd_in_file
251: WHERE ext_rcd_in_file_id = p_new_rcd_in_file_id
252: )
253: AND ext_data_elmt_id = (SELECT ext_data_elmt_id
254: FROM ben_ext_data_elmt

Line 689: FROM ben_ext_rcd_in_file RinF, ben_ext_rcd Rcd

685: );
686:
687: CURSOR c_ext_rcd_in_file(p_ext_file_id IN NUMBER) IS
688: SELECT RinF.*
689: FROM ben_ext_rcd_in_file RinF, ben_ext_rcd Rcd
690: WHERE RinF.ext_file_id = p_ext_file_id
691: AND RinF.ext_rcd_id = Rcd.ext_rcd_id
692: AND ((RinF.business_group_id IS NULL AND RinF.legislation_code IS NULL)
693: OR (RinF.legislation_code IS NOT NULL

Line 965: -- Insert into BEN_EXT_RCD_IN_FILE using Row Handler

961: END IF;
962:
963: END; -- Insert into BEN_EXT_RCD using Row Handler
964:
965: -- Insert into BEN_EXT_RCD_IN_FILE using Row Handler
966: ben_xrf_ins.ins
967: (
968: p_ext_rcd_in_file_id => l_new_ext_rcd_in_file_id -- OUT
969: ,p_seq_num => r_curr_ext_rcd_in_file.seq_num