APPS.JA_CN_CFS_REPORT_PKG dependencies on RG_REPORTS

Line 501: L_REPORT_NAME RG_REPORTS.NAME%TYPE;

497: -- Fix bug#6751696 add begin
498: L_ROW_NAME RG_REPORT_AXES.AXIS_SEQ%TYPE;
499: -- Fix bug#6751696 add end
500: L_ROW_DESCRIPTION RG_REPORT_AXES.DESCRIPTION%TYPE;
501: L_REPORT_NAME RG_REPORTS.NAME%TYPE;
502: L_LEDGER_NAME VARCHAR2(30);
503: L_INTERCOMPANY_FLAG JA_CN_CFS_ACTIVITIES_ALL.INTERCOMPANY_FLAG%TYPE;
504: L_TRANSACTION_TYPE JA_CN_CFS_ACTIVITIES_ALL.TRANSACTION_TYPE%TYPE;
505: L_BSV JA_CN_CFS_ACTIVITIES_ALL.Balancing_Segment%TYPE;--enhancment add

Line 551: ,RG_REPORTS RG

547: ,GP.PERIOD_NUM
548: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
549: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
550: ,RG_REPORT_AXES RRA
551: ,RG_REPORTS RG
552: ,GL_LEDGERS LED
553: ,GL_PERIODS GP
554: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
555: AND JCA.LEDGER_ID = P_LEDGER_ID

Line 594: ,RG_REPORTS RG

590: -- Fix bug#6751696 add end
591: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
592: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
593: ,RG_REPORT_AXES RRA
594: ,RG_REPORTS RG
595: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
596: AND JCA.PERIOD_NAME = P_PERIOD_NAME
597: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM
598: AND JCCA.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID

Line 649: ,RG_REPORTS RG

645: ,null--fix bug 7487373 add
646: ,JCA.Balancing_Segment--enhancment add
647: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
648: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
649: ,RG_REPORTS RG
650: ,RG_REPORT_AXES RRA
651: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
652: AND JCA.PERIOD_NAME = P_PERIOD_NAME
653: AND JCA.SOURCE = NVL(P_SOURCE,

Line 749: FROM RG_REPORTS

745:
746: --Get the Report Name
747: SELECT NAME
748: INTO L_REPORT_NAME
749: FROM RG_REPORTS
750: WHERE REPORT_ID = P_REPORT_ID;
751:
752: --get ledger name
753: SELECT name