DBA Data[Home] [Help]

APPS.JA_CN_JRCFI_EXPORT_PKG dependencies on RG_REPORTS

Line 73: FROM rg_reports rr, rg_report_axes rra

69:
70: -- to get the cash flow item rule
71: CURSOR cash_flow_item_rule_cur(pn_cfs_report_id NUMBER) IS
72: SELECT length(MAX(rra.axis_seq))
73: FROM rg_reports rr, rg_report_axes rra
74: WHERE rr.report_id = pn_cfs_report_id
75: AND rr.ROW_SET_ID = rra.axis_set_id;
76:
77: -- to get the cash flow items

Line 103: rg_reports rr,

99: FROM ja_cn_cfs_activities_all jccaa,
100: ja_cn_journal_lines jcjl,
101: ja_cn_cfs_assignments_all jccasa,
102: ja_cn_cfs_assign_sup_all jccasa1,
103: rg_reports rr,
104: gl_period_statuses gps,
105: ja_cn_voucher_number jcvn
106: --Update by Jianchao Chi, for cnaov2 upgrade 04-JAN-2011
107: --Add ja_cn_voucher_number table, voucher number and legal entity

Line 177: rg_reports rr,

173: FROM ja_cn_cfs_activities_all jccaa,
174: ja_cn_journal_lines jcjl,
175: ja_cn_cfs_assignments_all jccasa,
176: ja_cn_cfs_assign_sup_all jccasa1,
177: rg_reports rr,
178: gl_period_statuses gps,
179: ja_cn_voucher_number jcvn
180: --Update by Jianchao Chi, for cnaov2 upgrade 04-JAN-2011
181: --Add ja_cn_voucher_number table, voucher number and legal entity