APPS.JA_CN_FSG_XML_BANK_PKG dependencies on GL_ACCESS_SETS

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;