APPS.JA_CN_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_DISPLAY_SETS

Line 879: FROM rg_report_display_sets ds, rg_reports rp

875: --REPORT_DISPLAY_SET_ID
876: BEGIN
877: SELECT ds.report_display_set_id
878: INTO ln_report_display_set_id
879: FROM rg_report_display_sets ds, rg_reports rp
880: WHERE rp.report_id = pn_balance_sheet_id
881: AND rp.report_display_set_id = ds.report_display_set_id(+);
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN

Line 1012: FROM rg_report_display_sets ds, rg_reports rp

1008: --REPORT_DISPLAY_SET_ID
1009: BEGIN
1010: SELECT ds.report_display_set_id
1011: INTO ln_report_display_set_id
1012: FROM rg_report_display_sets ds, rg_reports rp
1013: WHERE rp.report_id = pn_profit_statement_id
1014: AND rp.report_display_set_id = ds.report_display_set_id(+);
1015: EXCEPTION
1016: WHEN NO_DATA_FOUND THEN

Line 1146: FROM rg_report_display_sets ds, rg_reports rp

1142: --REPORT_DISPLAY_SET_ID
1143: BEGIN
1144: SELECT ds.report_display_set_id
1145: INTO ln_report_display_set_id
1146: FROM rg_report_display_sets ds, rg_reports rp
1147: WHERE rp.report_id = pn_owners_equity_id
1148: AND rp.report_display_set_id = ds.report_display_set_id(+);
1149: EXCEPTION
1150: WHEN NO_DATA_FOUND THEN

Line 1281: FROM rg_report_display_sets ds, rg_reports rp

1277: --REPORT_DISPLAY_SET_ID
1278: BEGIN
1279: SELECT ds.report_display_set_id
1280: INTO ln_report_display_set_id
1281: FROM rg_report_display_sets ds, rg_reports rp
1282: WHERE rp.report_id = pn_csf_report_id
1283: AND rp.report_display_set_id = ds.report_display_set_id(+);
1284: EXCEPTION
1285: WHEN NO_DATA_FOUND THEN

Line 1877: FROM rg_report_display_sets ds, rg_reports rp

1873: --REPORT_DISPLAY_SET_ID
1874: BEGIN
1875: SELECT ds.report_display_set_id
1876: INTO ln_report_display_set_id
1877: FROM rg_report_display_sets ds, rg_reports rp
1878: WHERE rp.report_id = pn_balance_sheet_id
1879: AND rp.report_display_set_id = ds.report_display_set_id(+);
1880: EXCEPTION
1881: WHEN NO_DATA_FOUND THEN

Line 2010: FROM rg_report_display_sets ds, rg_reports rp

2006: --REPORT_DISPLAY_SET_ID
2007: BEGIN
2008: SELECT ds.report_display_set_id
2009: INTO ln_report_display_set_id
2010: FROM rg_report_display_sets ds, rg_reports rp
2011: WHERE rp.report_id = pn_profit_statement_id
2012: AND rp.report_display_set_id = ds.report_display_set_id(+);
2013: EXCEPTION
2014: WHEN NO_DATA_FOUND THEN

Line 2144: FROM rg_report_display_sets ds, rg_reports rp

2140: --REPORT_DISPLAY_SET_ID
2141: BEGIN
2142: SELECT ds.report_display_set_id
2143: INTO ln_report_display_set_id
2144: FROM rg_report_display_sets ds, rg_reports rp
2145: WHERE rp.report_id = pn_owners_equity_id
2146: AND rp.report_display_set_id = ds.report_display_set_id(+);
2147: EXCEPTION
2148: WHEN NO_DATA_FOUND THEN

Line 2279: FROM rg_report_display_sets ds, rg_reports rp

2275: --REPORT_DISPLAY_SET_ID
2276: BEGIN
2277: SELECT ds.report_display_set_id
2278: INTO ln_report_display_set_id
2279: FROM rg_report_display_sets ds, rg_reports rp
2280: WHERE rp.report_id = pn_csf_report_id
2281: AND rp.report_display_set_id = ds.report_display_set_id(+);
2282: EXCEPTION
2283: WHEN NO_DATA_FOUND THEN