APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_CONTENT_SETS

Line 225: FROM rg_report_content_sets cs, rg_reports rp

221: --CONTENT_SET_ID
222: BEGIN
223: SELECT cs.content_set_id
224: INTO ln_content_set_id
225: FROM rg_report_content_sets cs, rg_reports rp
226: WHERE rp.report_id = pn_balance_sheet_id
227: AND rp.content_set_id = cs.content_set_id(+);
228: EXCEPTION
229: WHEN NO_DATA_FOUND THEN

Line 358: FROM rg_report_content_sets cs, rg_reports rp

354: --CONTENT_SET_ID
355: BEGIN
356: SELECT cs.content_set_id
357: INTO ln_content_set_id
358: FROM rg_report_content_sets cs, rg_reports rp
359: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
360: AND rp.content_set_id = cs.content_set_id(+);
361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN

Line 490: FROM rg_report_content_sets cs, rg_reports rp

486: --CONTENT_SET_ID
487: BEGIN
488: SELECT cs.content_set_id
489: INTO ln_content_set_id
490: FROM rg_report_content_sets cs, rg_reports rp
491: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
492: AND rp.content_set_id = cs.content_set_id(+);
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN