In R12, the corresponding secondary ledger CCID is obtained through the CCID of primary ledger.

-- Get ledger mapping ID
Begin
Select Coa_mapping_id
Into Vl_mapping_id
From Gl_coa_mappings
Where Name = Vgc_mapping_name
And Rownum =   1 ;
End ;

-- Clear temp table
Begin
Delete Gl_accts_map_int_gt;
End ;
-- Insert R12 CCID
Begin
Insert   Into Gl_accts_map_int_gt
(From_ccid, coa_mapping_id)
Values
(Pi_ccid, vl_mapping_id );
End ;
-- Call API
Gl_accounts_map_grp.map (mapping_name => Vgc_mapping_name,
Create_ccid => True,
Debug =>   Null );

Commit ;
-- Get secondary ledger CCID
Begin
Select To_ccid Into Vl_convert_ccid From Gl_accts_map_int_gt;
End ;
-- Return CCID
Return Vl_convert_ccid;