DBA Data[Home] [Help]

APPS.JA_CN_CFS_REPORT_PKG dependencies on JA_CN_CFS_ASSIGNMENTS_ALL

Line 549: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA

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
553: ,GL_PERIODS GP

Line 592: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA

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
596: AND JCA.PERIOD_NAME = P_PERIOD_NAME

Line 648: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA

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
652: AND JCA.PERIOD_NAME = P_PERIOD_NAME