APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_DISPLAY_SETS

Line 247: FROM rg_report_display_sets ds, rg_reports rp

243: --REPORT_DISPLAY_SET_ID
244: BEGIN
245: SELECT ds.report_display_set_id
246: INTO ln_report_display_set_id
247: FROM rg_report_display_sets ds, rg_reports rp
248: WHERE rp.report_id = pn_balance_sheet_id
249: AND rp.report_display_set_id = ds.report_display_set_id(+);
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN

Line 380: FROM rg_report_display_sets ds, rg_reports rp

376: --REPORT_DISPLAY_SET_ID
377: BEGIN
378: SELECT ds.report_display_set_id
379: INTO ln_report_display_set_id
380: FROM rg_report_display_sets ds, rg_reports rp
381: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
382: AND rp.report_display_set_id = ds.report_display_set_id(+);
383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN

Line 512: FROM rg_report_display_sets ds, rg_reports rp

508: --REPORT_DISPLAY_SET_ID
509: BEGIN
510: SELECT ds.report_display_set_id
511: INTO ln_report_display_set_id
512: FROM rg_report_display_sets ds, rg_reports rp
513: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
514: AND rp.report_display_set_id = ds.report_display_set_id(+);
515: EXCEPTION
516: WHEN NO_DATA_FOUND THEN