APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG dependencies on RG_REPORT_AXIS_SETS

Line 178: FROM rg_report_axis_sets rs, rg_reports rp

174: --(1) Submit Balance Sheet Report and get this program request ID.
175: --ROW_SET_ID
176: SELECT rs.axis_set_id
177: INTO ln_row_set_id
178: FROM rg_report_axis_sets rs, rg_reports rp
179: WHERE rp.report_id = pn_balance_sheet_id
180: AND rp.row_set_id = rs.axis_set_id;
181: --COLUMN_SET_ID
182: SELECT cs.axis_set_id

Line 184: FROM rg_report_axis_sets cs, rg_reports rp

180: AND rp.row_set_id = rs.axis_set_id;
181: --COLUMN_SET_ID
182: SELECT cs.axis_set_id
183: INTO ln_clolumn_set_id
184: FROM rg_report_axis_sets cs, rg_reports rp
185: WHERE rp.report_id = pn_balance_sheet_id
186: AND rp.column_set_id = cs.axis_set_id;
187: --Unit of Measure ID/currency
188: BEGIN

Line 311: FROM rg_report_axis_sets rs, rg_reports rp

307: --(2) Submit Revenue and Expenditure Report and get this program request ID.
308: --ROW_SET_ID
309: SELECT rs.axis_set_id
310: INTO ln_row_set_id
311: FROM rg_report_axis_sets rs, rg_reports rp
312: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
313: AND rp.row_set_id = rs.axis_set_id;
314: --COLUMN_SET_ID
315: SELECT cs.axis_set_id

Line 317: FROM rg_report_axis_sets cs, rg_reports rp

313: AND rp.row_set_id = rs.axis_set_id;
314: --COLUMN_SET_ID
315: SELECT cs.axis_set_id
316: INTO ln_clolumn_set_id
317: FROM rg_report_axis_sets cs, rg_reports rp
318: WHERE rp.report_id = pn_revenue_expenditure_id --parameter: pn_revenue_expenditure_id
319: AND rp.column_set_id = cs.axis_set_id;
320: --Unit of Measure ID/currency
321: BEGIN

Line 443: FROM rg_report_axis_sets rs, rg_reports rp

439: --(3) Submit Expenditure Detail Report and get this program request ID.
440: --ROW_SET_ID
441: SELECT rs.axis_set_id
442: INTO ln_row_set_id
443: FROM rg_report_axis_sets rs, rg_reports rp
444: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
445: AND rp.row_set_id = rs.axis_set_id;
446: --COLUMN_SET_ID
447: SELECT cs.axis_set_id

Line 449: FROM rg_report_axis_sets cs, rg_reports rp

445: AND rp.row_set_id = rs.axis_set_id;
446: --COLUMN_SET_ID
447: SELECT cs.axis_set_id
448: INTO ln_clolumn_set_id
449: FROM rg_report_axis_sets cs, rg_reports rp
450: WHERE rp.report_id = pn_expenditure_detail_id --parameter: pn_expenditure_detail_id
451: AND rp.column_set_id = cs.axis_set_id;
452: --Unit of Measure ID/currency
453: BEGIN