APPS.JA_CN_CFS_REPORT_PKG dependencies on JA_CN_CFS_ACTIVITIES_ALL

Line 486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;

482: L_TRX_NUMBER varchar2(240):=null;
483: -- Fix bug#6697073 end --------------------------
484:
485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;
487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;
488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);

Line 487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;

483: -- Fix bug#6697073 end --------------------------
484:
485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;
487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;
488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);
491: L_THIRD_PARTY_NUMBER varchar2(100);

Line 488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;

484:
485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;
487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;
488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);
491: L_THIRD_PARTY_NUMBER varchar2(100);
492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;

Line 489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;

485: L_PERIOD_NUM GL_PERIODS.PERIOD_NUM%TYPE;
486: L_PERIOD_NAME JA_CN_CFS_ACTIVITIES_ALL.PERIOD_NAME%TYPE;
487: L_FUNC_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.FUNC_AMOUNT%TYPE;
488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);
491: L_THIRD_PARTY_NUMBER varchar2(100);
492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;
493: L_SOURCE JA_CN_CFS_ACTIVITIES_ALL.SOURCE%TYPE;

Line 492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;

488: L_ORIGINAL_AMOUNT JA_CN_CFS_ACTIVITIES_ALL.ORIGINAL_AMOUNT%TYPE;
489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);
491: L_THIRD_PARTY_NUMBER varchar2(100);
492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;
493: L_SOURCE JA_CN_CFS_ACTIVITIES_ALL.SOURCE%TYPE;
494: -- Fix bug#6751696 delete begin
495: --L_ROW_NAME RG_REPORT_AXES.AXIS_NAME%TYPE;
496: -- Fix bug#6751696 delete end

Line 493: L_SOURCE JA_CN_CFS_ACTIVITIES_ALL.SOURCE%TYPE;

489: L_DETAILED_CFS_ITEM JA_CN_CFS_ACTIVITIES_ALL.DETAILED_CFS_ITEM%TYPE;
490: L_THIRD_PARTY_NAME varchar2(100);
491: L_THIRD_PARTY_NUMBER varchar2(100);
492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;
493: L_SOURCE JA_CN_CFS_ACTIVITIES_ALL.SOURCE%TYPE;
494: -- Fix bug#6751696 delete begin
495: --L_ROW_NAME RG_REPORT_AXES.AXIS_NAME%TYPE;
496: -- Fix bug#6751696 delete end
497: -- Fix bug#6751696 add begin

Line 503: L_INTERCOMPANY_FLAG JA_CN_CFS_ACTIVITIES_ALL.INTERCOMPANY_FLAG%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
506:
507: -- Fix bug#6697073 begin----------------------------------------

Line 504: L_TRANSACTION_TYPE JA_CN_CFS_ACTIVITIES_ALL.TRANSACTION_TYPE%TYPE;

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
506:
507: -- Fix bug#6697073 begin----------------------------------------
508: -- L_SOURCE_AP VARCHAR2(10) := 'AP';

Line 505: L_BSV JA_CN_CFS_ACTIVITIES_ALL.Balancing_Segment%TYPE;--enhancment add

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
506:
507: -- Fix bug#6697073 begin----------------------------------------
508: -- L_SOURCE_AP VARCHAR2(10) := 'AP';
509: L_SOURCE_AP VARCHAR2(10) := 'SQLAP';

Line 548: FROM JA_CN_CFS_ACTIVITIES_ALL JCA

544: , P_REPORT_ID NUMBER
545: , p_bsv VARCHAR2) IS--enhancment add
546: SELECT DISTINCT JCA.PERIOD_NAME
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

Line 591: FROM JA_CN_CFS_ACTIVITIES_ALL JCA

587: -- Fix bug#6751696 delete end
588: -- Fix bug#6751696 add begin
589: RRA.AXIS_SEQ
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

Line 647: FROM JA_CN_CFS_ACTIVITIES_ALL JCA

643: ,JCA.TRX_NUMBER
644: -- Fix bug#6697073 end----------------------------------
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