57:
58: -- Find report_id for asset
59: SELECT R.report_id
60: INTO X_asset_report_id
61: FROM fnd_concurrent_programs c,
62: fnd_application a,
63: fa_rx_reports r
64: WHERE c.application_id = a.application_id
65: AND a.application_short_name ='JG'
126: -- Find report_id for Retirement
127:
128: SELECT R.report_id
129: INTO X_rtmnt_report_id
130: FROM fnd_concurrent_programs c,
131: fnd_application a,
132: fa_rx_reports r
133: WHERE c.application_id = a.application_id
134: AND a.application_short_name ='JG'