APPS.JA_CN_FSG_XML_BANK_PKG dependencies on RG_REPORT_AXIS_SETS

Line 960: FROM rg_report_axis_sets rs, rg_reports rp

956: --(1) Balance Sheet Report and get this program request ID.
957: --ROW_SET_ID
958: SELECT rs.axis_set_id
959: INTO ln_row_set_id
960: FROM rg_report_axis_sets rs, rg_reports rp
961: WHERE rp.report_id = pn_balance_sheet_id
962: AND rp.row_set_id = rs.axis_set_id;
963: --COLUMN_SET_ID
964: SELECT cs.axis_set_id

Line 966: FROM rg_report_axis_sets cs, rg_reports rp

962: AND rp.row_set_id = rs.axis_set_id;
963: --COLUMN_SET_ID
964: SELECT cs.axis_set_id
965: INTO ln_clolumn_set_id
966: FROM rg_report_axis_sets cs, rg_reports rp
967: WHERE rp.report_id = pn_balance_sheet_id
968: AND rp.column_set_id = cs.axis_set_id;
969: --Unit of Measure ID/currency
970: BEGIN

Line 1114: FROM rg_report_axis_sets rs, rg_reports rp

1110: --(2) Profit Statement Report and get this program request ID.
1111: --ROW_SET_ID
1112: SELECT rs.axis_set_id
1113: INTO ln_row_set_id
1114: FROM rg_report_axis_sets rs, rg_reports rp
1115: WHERE rp.report_id = pn_profit_statement_id
1116: AND rp.row_set_id = rs.axis_set_id;
1117: --COLUMN_SET_ID
1118: SELECT cs.axis_set_id

Line 1120: FROM rg_report_axis_sets cs, rg_reports rp

1116: AND rp.row_set_id = rs.axis_set_id;
1117: --COLUMN_SET_ID
1118: SELECT cs.axis_set_id
1119: INTO ln_clolumn_set_id
1120: FROM rg_report_axis_sets cs, rg_reports rp
1121: WHERE rp.report_id = pn_profit_statement_id
1122: AND rp.column_set_id = cs.axis_set_id;
1123: --Unit of Measure ID/currency
1124: BEGIN

Line 1269: FROM rg_report_axis_sets rs, rg_reports rp

1265: -- (3) Statement of Cash flows Report and get this program request ID.
1266: --ROW_SET_ID
1267: SELECT rs.axis_set_id
1268: INTO ln_row_set_id
1269: FROM rg_report_axis_sets rs, rg_reports rp
1270: WHERE rp.report_id = pn_csf_report_id
1271: AND rp.row_set_id = rs.axis_set_id;
1272: --COLUMN_SET_ID
1273: SELECT cs.axis_set_id

Line 1275: FROM rg_report_axis_sets cs, rg_reports rp

1271: AND rp.row_set_id = rs.axis_set_id;
1272: --COLUMN_SET_ID
1273: SELECT cs.axis_set_id
1274: INTO ln_clolumn_set_id
1275: FROM rg_report_axis_sets cs, rg_reports rp
1276: WHERE rp.report_id = pn_csf_report_id
1277: AND rp.column_set_id = cs.axis_set_id;
1278: --Unit of Measure ID/currency
1279: BEGIN

Line 1424: FROM rg_report_axis_sets rs, rg_reports rp

1420: --(4) Owners Equity Report and get this program request ID.
1421: --ROW_SET_ID
1422: SELECT rs.axis_set_id
1423: INTO ln_row_set_id
1424: FROM rg_report_axis_sets rs, rg_reports rp
1425: WHERE rp.report_id = pn_owners_equity_id
1426: AND rp.row_set_id = rs.axis_set_id;
1427: --COLUMN_SET_ID
1428: SELECT cs.axis_set_id

Line 1430: FROM rg_report_axis_sets cs, rg_reports rp

1426: AND rp.row_set_id = rs.axis_set_id;
1427: --COLUMN_SET_ID
1428: SELECT cs.axis_set_id
1429: INTO ln_clolumn_set_id
1430: FROM rg_report_axis_sets cs, rg_reports rp
1431: WHERE rp.report_id = pn_owners_equity_id
1432: AND rp.column_set_id = cs.axis_set_id;
1433: --Unit of Measure ID/currency
1434: BEGIN