APPS.JA_CN_CFS_REPORT_PKG dependencies on GL_LEDGERS

Line 552: ,GL_LEDGERS LED

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
556: AND JCA.GL_DATE >= L_DATE_FROM

Line 755: FROM gl_ledgers

751:
752: --get ledger name
753: SELECT name
754: INTO l_ledger_name
755: FROM gl_ledgers
756: WHERE ledger_id=p_ledger_id;
757: --write the parameter infomation into variable
758: --l_xml_parameter and last into l_xml_report
759: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 850: FROM GL_LEDGERS LED

846: ,GP2.PERIOD_YEAR
847: INTO L_PERIOD_SET_NAME
848: ,L_YEAR_FROM
849: ,L_YEAR_TO
850: FROM GL_LEDGERS LED
851: ,GL_PERIODS GP1
852: ,GL_PERIODS GP2
853: WHERE LED.LEDGER_ID = P_LEDGER_ID
854: AND GP1.PERIOD_SET_NAME = LED.PERIOD_SET_NAME

Line 869: FROM GL_LEDGERS

865:
866: --get period type
867: SELECT ACCOUNTED_PERIOD_TYPE
868: INTO L_PERIOD_TYPE
869: FROM GL_LEDGERS
870: WHERE LEDGER_ID = P_LEDGER_ID;
871:
872: --get period number for start period
873: SELECT PERIOD_YEAR * 1000 + PERIOD_NUM