DBA Data[Home] [Help]

APPS.JA_CN_CFI_EXPORT_PKG dependencies on RG_REPORT_AXES

Line 96: FROM RG_REPORT_AXES RRA,

92: '0',
93: 'Others',
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

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