DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on RG_REPORT_CALCULATIONS

Line 6110: FROM rg_report_calculations

6106: LOOP
6107: BEGIN
6108: SELECT axis_seq_low
6109: INTO l_acct_axis_seq
6110: FROM rg_report_calculations
6111: WHERE axis_set_id = l_row_set_id
6112: AND axis_seq = l_axis_seq
6113: AND ROWNUM < 2;
6114: EXCEPTION

Line 6322: AND ROWNUM = 1) --There may exist multiple records in rg_report_calculations for a axis_set_id and axis_seq

6318: '|'
6319: FROM rg_report_axes r2
6320: WHERE r2.axis_set_id = l_row_set_id
6321: AND r2.axis_seq = J150_rec.field8
6322: AND ROWNUM = 1) --There may exist multiple records in rg_report_calculations for a axis_set_id and axis_seq
6323: WHERE request_id = g_concurrent_request_id
6324: AND field1 = 'J150'
6325: AND field8 = J150_rec.field8;
6326: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'After update of calculations');