APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on RG_REPORT_AXIS_CONTENTS

Line 4315: ,rg_report_axis_contents r4

4311: (SELECT DECODE('''||g_agglutination_code_source||''',''FSG_LINE'',to_char(r3.sequence),r3.description) row_seq_ident
4312: FROM rg_reports r1
4313: ,rg_report_axis_sets r2
4314: ,rg_report_axes_v r3
4315: ,rg_report_axis_contents r4
4316: WHERE r1.report_id = '||g_balance_statement_report_id||'
4317: AND r1.row_set_id = r2.axis_set_id
4318: AND r2.axis_set_id = r3.axis_set_id
4319: AND r3.axis_set_id = r4.axis_set_id

Line 4365: ,rg_report_axis_contents r4

4361: (SELECT DECODE('''||g_agglutination_code_source||''',''FSG_LINE'',to_char(r3.sequence),r3.description) row_seq_ident
4362: FROM rg_reports r1
4363: ,rg_report_axis_sets r2
4364: ,rg_report_axes_v r3
4365: ,rg_report_axis_contents r4
4366: WHERE r1.report_id = '||g_income_statement_report_id||'
4367: AND r1.row_set_id = r2.axis_set_id
4368: AND r2.axis_set_id = r3.axis_set_id
4369: AND r3.axis_set_id = r4.axis_set_id

Line 5994: FROM rg_report_axis_contents

5990:
5991: l_cnt := 0;
5992: SELECT COUNT(*) -- Checking for account assignements
5993: INTO l_cnt
5994: FROM rg_report_axis_contents
5995: WHERE axis_set_id = l_row_set_id
5996: AND axis_seq = J100_rec.field8;
5997:
5998: IF l_cnt > 0 THEN --account assignments exists

Line 6004: FROM rg_report_axis_contents

6000: -- FND_FILE.PUT_LINE(FND_FILE.LOG,J100_rec.field8||' '||J100_rec.field6);
6001: l_prev_acct_type := 0;
6002:
6003: OPEN acct_cur FOR 'SELECT '||g_account_segment||'_LOW,'||g_account_segment||'_HIGH
6004: FROM rg_report_axis_contents
6005: WHERE axis_set_id ='|| l_row_set_id||
6006: 'AND axis_seq ='||J100_rec.field8;
6007: LOOP
6008: FETCH acct_cur INTO acct_low,acct_high;

Line 6122: FROM rg_report_axis_contents

6118: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_acct_axis_seq: '||l_acct_axis_seq);
6119: l_cnt := 0;
6120: SELECT COUNT(*) -- Checking for account assignements
6121: INTO l_cnt
6122: FROM rg_report_axis_contents
6123: WHERE axis_set_id = l_row_set_id
6124: AND axis_seq = l_acct_axis_seq;
6125: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cnt: '||l_cnt);
6126:

Line 6273: FROM rg_report_axis_contents

6269:
6270: l_cnt := 0;
6271: SELECT COUNT(*) -- Checking for account assignements
6272: INTO l_cnt
6273: FROM rg_report_axis_contents
6274: WHERE axis_set_id = l_row_set_id
6275: AND axis_seq = J150_rec.field8;
6276:
6277: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'After cnt'||l_cnt);