Sq1

--CHART OF ACCOUNTS RANGE CHANGES delete from chart_of_accounts_range where start_branch_cd in ('684', '685', '686', '687', '688', '689'); -- Regular FHSA Ranges insert into chart_of_accounts_range ( client_nbr, start_branch_cd, start_account_cd, end_branch_cd, end_account_cd, range_desc_tx, pro_fg, last_request_id, business_subgroup_cd, business_group_cd, product_range_cd, internal_account_type_cd ) select '0066', branch_cd, start_num, branch_cd, end_num, 'Plan Account Range - FHSA-ICS', 'N', 'DBRII-XXXX', 'WG', 'WG', '3', '02' from ( select '684' as branch_cd, '00000' as start_num, '96999' as end_num from dual union all select '685', '00000', '96999' from dual union all select '686', '00000', '96999' from dual union all select '687', '00000', '96999' from dual union all select '688', '00000', '96999' from dual union all select '689', '00000', '96999' from dual ); -- FHSA PRO Ranges insert into chart_of_accounts_range ( client_nbr, start_branch_cd, start_account_cd, end_branch_cd, end_account_cd, range_desc_tx, pro_fg, last_request_id, business_subgroup_cd, business_group_cd, product_range_cd, internal_account_type_cd ) select '0066', branch_cd, start_num, branch_cd, end_num, 'Plan Account Range - FHSA PRO-ICS', 'Y', 'DBRII-XXXX', 'WG', 'WG', '3', '02' from ( select '684' as branch_cd, '97000' as start_num, '99999' as end_num from dual union all select '685', '97000', '99999' from dual union all select '686', '97000', '99999' from dual union all select '687', '97000', '99999' from dual union all select '688', '97000', '99999' from dual union all select '689', '97000', '99999' from dual ); --MYC ECIF PRODUCT MAP delete from myc_ecif_product_map where start_branch_cd in ('684', '685', '686', '687', '688', '689'); -- Regular FHSA Product Mappings insert into myc_ecif_product_map ( myc_ecif_product_map_id, start_branch_cd, end_branch_cd, start_account_nbr, end_account_nbr, range_desc, registered_flg, ecif_product_code, ecif_sub_product_code, last_request_id ) select seq_myc_ecif_product_map_id.nextval, branch_cd, branch_cd, start_num, end_num, 'Investment Consulting Service FHSA', 'Y', 'WRSP', 'WG 002', 'DBRII-XXXX' from ( select '684' as branch_cd, '00000' as start_num, '96999' as end_num from dual union all select '685', '00000', '96999' from dual union all select '686', '00000', '96999' from dual union all select '687', '00000', '96999' from dual union all select '688', '00000', '96999' from dual union all select '689', '00000', '96999' from dual ); -- FHSA PRO Product Mappings insert into myc_ecif_product_map ( myc_ecif_product_map_id, start_branch_cd, end_branch_cd, start_account_nbr, end_account_nbr, range_desc, registered_flg, ecif_product_code, ecif_sub_product_code, last_request_id ) select seq_myc_ecif_product_map_id.nextval, branch_cd, branch_cd, start_num, end_num, 'Investment Consulting Service FHSA - PRO', 'Y', 'WRSP', 'WG 002', 'DBRII-XXXX' from ( select '684' as branch_cd, '97000' as start_num, '99999' as end_num from dual union all select '685', '97000', '99999' from dual union all select '686', '97000', '99999' from dual union all select '687', '97000', '99999' from dual union all select '688', '97000', '99999' from dual union all select '689', '97000', '99999' from dual ); spool off

Feb 16, 2025 - 00:20


--CHART OF ACCOUNTS RANGE CHANGES
delete from chart_of_accounts_range where start_branch_cd in ('684', '685', '686', '687', '688', '689');

-- Regular FHSA Ranges
insert into chart_of_accounts_range (
    client_nbr, start_branch_cd, start_account_cd, end_branch_cd, 
    end_account_cd, range_desc_tx, pro_fg, last_request_id,
    business_subgroup_cd, business_group_cd, product_range_cd, 
    internal_account_type_cd
)
select '0066', branch_cd, start_num, branch_cd, end_num,
       'Plan Account Range - FHSA-ICS', 'N', 'DBRII-XXXX',
       'WG', 'WG', '3', '02'
from (
    select '684' as branch_cd, '00000' as start_num, '96999' as end_num from dual union all
    select '685', '00000', '96999' from dual union all
    select '686', '00000', '96999' from dual union all
    select '687', '00000', '96999' from dual union all
    select '688', '00000', '96999' from dual union all
    select '689', '00000', '96999' from dual
);

-- FHSA PRO Ranges
insert into chart_of_accounts_range (
    client_nbr, start_branch_cd, start_account_cd, end_branch_cd, 
    end_account_cd, range_desc_tx, pro_fg, last_request_id,
    business_subgroup_cd, business_group_cd, product_range_cd, 
    internal_account_type_cd
)
select '0066', branch_cd, start_num, branch_cd, end_num,
       'Plan Account Range - FHSA PRO-ICS', 'Y', 'DBRII-XXXX',
       'WG', 'WG', '3', '02'
from (
    select '684' as branch_cd, '97000' as start_num, '99999' as end_num from dual union all
    select '685', '97000', '99999' from dual union all
    select '686', '97000', '99999' from dual union all
    select '687', '97000', '99999' from dual union all
    select '688', '97000', '99999' from dual union all
    select '689', '97000', '99999' from dual
);

--MYC ECIF PRODUCT MAP
delete from myc_ecif_product_map where start_branch_cd in ('684', '685', '686', '687', '688', '689');

-- Regular FHSA Product Mappings
insert into myc_ecif_product_map (
    myc_ecif_product_map_id, start_branch_cd, end_branch_cd, 
    start_account_nbr, end_account_nbr, range_desc, registered_flg, 
    ecif_product_code, ecif_sub_product_code, last_request_id
)
select seq_myc_ecif_product_map_id.nextval, branch_cd, branch_cd,
       start_num, end_num, 'Investment Consulting Service FHSA', 'Y',
       'WRSP', 'WG 002', 'DBRII-XXXX'
from (
    select '684' as branch_cd, '00000' as start_num, '96999' as end_num from dual union all
    select '685', '00000', '96999' from dual union all
    select '686', '00000', '96999' from dual union all
    select '687', '00000', '96999' from dual union all
    select '688', '00000', '96999' from dual union all
    select '689', '00000', '96999' from dual
);

-- FHSA PRO Product Mappings
insert into myc_ecif_product_map (
    myc_ecif_product_map_id, start_branch_cd, end_branch_cd, 
    start_account_nbr, end_account_nbr, range_desc, registered_flg, 
    ecif_product_code, ecif_sub_product_code, last_request_id
)
select seq_myc_ecif_product_map_id.nextval, branch_cd, branch_cd,
       start_num, end_num, 'Investment Consulting Service FHSA - PRO', 'Y',
       'WRSP', 'WG 002', 'DBRII-XXXX'
from (
    select '684' as branch_cd, '97000' as start_num, '99999' as end_num from dual union all
    select '685', '97000', '99999' from dual union all
    select '686', '97000', '99999' from dual union all
    select '687', '97000', '99999' from dual union all
    select '688', '97000', '99999' from dual union all
    select '689', '97000', '99999' from dual
);

spool off