APPS.JA_CN_FSG_XML_BANK_PKG dependencies on GL_LEDGERS

Line 735: from gl_ledgers

731: select application_column_name, default_value
732: from FND_ID_FLEX_SEGMENTS_VL
733: where id_flex_code = 'GL#'
734: and id_flex_num = (select chart_of_accounts_id
735: from gl_ledgers
736: where ledger_id =P_LEDGER_ID);
737: l_segment cur_segments%ROWTYPE;
738: l_bsv_segment varchar2(20);
739: l_coa_id pls_integer;

Line 745: from gl_ledgers

741: l_override VARCHAR2(1000);
742: BEGIN
743: select chart_of_accounts_id
744: into l_coa_id
745: from gl_ledgers
746: where ledger_id = P_LEDGER_ID;
747: select fnd_flex_ext.get_delimiter('SQLGL',
748: 'GL#',
749: l_coa_id

Line 813: from gl_ledgers

809: if l_fsg_currency is null then
810: begin
811: select CURRENCY_CODE
812: INTO l_fsg_currency
813: from gl_ledgers
814: where LEDGER_ID = P_LEDGER_ID
815: and ledger_category_code = 'SECONDARY';
816: exception
817: when no_data_found then

Line 976: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

972: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_balance_sheet_id) ;
973: If lv_unit_of_measure_id is null then
974: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
975: INTO lv_unit_of_measure_id
976: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
977: WHERE ldg.ledger_id = acc.default_ledger_id
978: AND acc.access_set_id = pn_data_access_set_id
979: AND rp.report_id = pn_balance_sheet_id;
980: end if;

Line 1130: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1126: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_profit_statement_id) ;
1127: If lv_unit_of_measure_id is null then
1128: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1129: INTO lv_unit_of_measure_id
1130: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1131: WHERE ldg.ledger_id = acc.default_ledger_id
1132: AND acc.access_set_id = pn_data_access_set_id
1133: AND rp.report_id = pn_profit_statement_id;
1134: end if;

Line 1285: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1281: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_csf_report_id) ;
1282: If lv_unit_of_measure_id is null then
1283: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1284: INTO lv_unit_of_measure_id
1285: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1286: WHERE ldg.ledger_id = acc.default_ledger_id
1287: AND acc.access_set_id = pn_data_access_set_id
1288: AND rp.report_id = pn_csf_report_id;
1289: end if;

Line 1440: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc

1436: lv_unit_of_measure_id:= Get_FSG_Currency(pn_ledger_id,pn_owners_equity_id) ;
1437: If lv_unit_of_measure_id is null then
1438: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1439: INTO lv_unit_of_measure_id
1440: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1441: WHERE ldg.ledger_id = acc.default_ledger_id
1442: AND acc.access_set_id = pn_data_access_set_id
1443: AND rp.report_id = pn_owners_equity_id;
1444: end if;