DBA Data[Home] [Help]

APPS.JA_CN_CFI_EXPORT_PKG dependencies on RG_REPORTS

Line 98: RG_REPORTS RP

94: '2',
95: ' ') AS CFI_ATTRIBUTE --Cash Flow Item Attribute
96: FROM RG_REPORT_AXES RRA,
97: JA_CN_CFS_ASSIGN_SUP_ALL CASA,
98: RG_REPORTS RP
99: WHERE RRA.AXIS_SET_ID = CASA.AXIS_SET_ID
100: AND RRA.AXIS_SEQ = CASA.AXIS_SEQ
101: AND RRA.AXIS_SET_ID = RP.ROW_SET_ID --CFS Row set id
102: AND CASA.CHART_OF_ACCOUNTS_ID = pn_chart_of_account_id --parameter: pn_chart_of_account_id

Line 130: FROM RG_REPORT_AXES RRA, RG_REPORTS RP

126: --Get the max length of cfs row line number
127: BEGIN
128: SELECT MAX(LENGTH(RRA.AXIS_SEQ))
129: INTO ln_max_length
130: FROM RG_REPORT_AXES RRA, RG_REPORTS RP
131: WHERE RP.ROW_SET_ID = RRA.AXIS_SET_ID
132: AND RP.REPORT_ID = pn_cfs_report_id; --parameter: pn_cfs_report_id
133:
134: EXCEPTION

Line 245: FROM RG_REPORTS RP

241: --Get cfs report name for error message
242: BEGIN
243: SELECT RP.NAME
244: INTO lv_report_name
245: FROM RG_REPORTS RP
246: WHERE RP.REPORT_ID = pn_cfs_report_id; --parameter: pn_cfs_report_id
247: EXCEPTION
248: WHEN OTHERS THEN
249: lv_report_name := '';