APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on GL_LEDGERS

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

819: --Unit of Measure ID/currency
820: BEGIN
821: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
822: INTO lv_unit_of_measure_id
823: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
824: WHERE ldg.ledger_id = acc.default_ledger_id
825: AND acc.access_set_id = pn_data_access_set_id
826: AND rp.report_id = pn_balance_sheet_id;
827: EXCEPTION

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

952: --Unit of Measure ID/currency
953: BEGIN
954: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
955: INTO lv_unit_of_measure_id
956: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
957: WHERE ldg.ledger_id = acc.default_ledger_id
958: AND acc.access_set_id = pn_profit_statement_id
959: AND rp.report_id = pn_balance_sheet_id;
960: EXCEPTION

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

1086: --Unit of Measure ID/currency
1087: BEGIN
1088: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1089: INTO lv_unit_of_measure_id
1090: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1091: WHERE ldg.ledger_id = acc.default_ledger_id
1092: AND acc.access_set_id = pn_owners_equity_id
1093: AND rp.report_id = pn_balance_sheet_id;
1094: EXCEPTION

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

1221: --Unit of Measure ID/currency
1222: BEGIN
1223: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1224: INTO lv_unit_of_measure_id
1225: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1226: WHERE ldg.ledger_id = acc.default_ledger_id
1227: AND acc.access_set_id = pn_csf_report_id
1228: AND rp.report_id = pn_balance_sheet_id;
1229: EXCEPTION

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

1817: --Unit of Measure ID/currency
1818: BEGIN
1819: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1820: INTO lv_unit_of_measure_id
1821: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1822: WHERE ldg.ledger_id = acc.default_ledger_id
1823: AND acc.access_set_id = pn_data_access_set_id
1824: AND rp.report_id = pn_balance_sheet_id;
1825: EXCEPTION

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

1950: --Unit of Measure ID/currency
1951: BEGIN
1952: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
1953: INTO lv_unit_of_measure_id
1954: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
1955: WHERE ldg.ledger_id = acc.default_ledger_id
1956: AND acc.access_set_id = pn_profit_statement_id
1957: AND rp.report_id = pn_balance_sheet_id;
1958: EXCEPTION

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

2084: --Unit of Measure ID/currency
2085: BEGIN
2086: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
2087: INTO lv_unit_of_measure_id
2088: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
2089: WHERE ldg.ledger_id = acc.default_ledger_id
2090: AND acc.access_set_id = pn_owners_equity_id
2091: AND rp.report_id = pn_balance_sheet_id;
2092: EXCEPTION

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

2219: --Unit of Measure ID/currency
2220: BEGIN
2221: SELECT nvl(rp.unit_of_measure_id, ldg.currency_code)
2222: INTO lv_unit_of_measure_id
2223: FROM rg_reports rp, gl_ledgers ldg, gl_access_sets acc
2224: WHERE ldg.ledger_id = acc.default_ledger_id
2225: AND acc.access_set_id = pn_csf_report_id
2226: AND rp.report_id = pn_balance_sheet_id;
2227: EXCEPTION