APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_LEDGERS

Line 157: ,GL_LEDGERS ledger

153: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
154: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
155: seg_fsav_gcc
156: FROM GL_CODE_COMBINATIONS gcc
157: ,GL_LEDGERS ledger
158: ,FND_ID_FLEX_SEGMENTS FIFS
159: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
160: ,FND_FLEX_VALUE_SETS FFVS
161: ,FND_FLEX_VALUES FFV

Line 490: ,GL_LEDGERS ledger

486: ,FFV.Flex_Value flex_value
487: ,FFVT.Description flex_desc
488: BULK COLLECT INTO l_all_acc_seg
489: FROM GL_CODE_COMBINATIONS gcc
490: ,GL_LEDGERS ledger
491: ,FND_ID_FLEX_SEGMENTS FIFS
492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
493: ,FND_FLEX_VALUE_SETS FFVS
494: ,FND_FLEX_VALUES FFV

Line 693: FROM gl_periods gp, GL_LEDGERS ledger

689:
690: --Cursor to get all periods between (P_START_PERIOD, P_END_PERIOD).
691: CURSOR c_period_name IS
692: SELECT gp.period_name, gp.period_year, gp.period_num
693: FROM gl_periods gp, GL_LEDGERS ledger
694: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
695: AND ledger.period_set_name = gp.PERIOD_SET_NAME
696: AND ledger.accounted_period_type = gp.period_type
697: AND gp.start_date between

Line 901: FROM GL_LEDGERS ledger

897:
898: --Get ledger Name
899: SELECT ledger.name
900: INTO l_ledger_name
901: FROM GL_LEDGERS ledger
902: WHERE ledger.ledger_id = l_ledger_id
903: ;
904: -- FND_FILE.put_line(FND_FILE.output, '' ||l_sob_name||'');
905: SELECT XMLELEMENT( "LEDGER_NAME",l_ledger_name ) INTO l_xml_item FROM dual;

Line 1379: FROM gl_periods gp, GL_LEDGERS ledger

1375: , gp.period_year
1376: , gp.period_num
1377: , gp.start_date
1378: , gp.end_date
1379: FROM gl_periods gp, GL_LEDGERS ledger
1380: WHERE ledger.ledger_id = l_ledger_id --using variable l_ledger_id
1381: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1382: AND ledger.accounted_period_type = gp.period_type
1383: AND gp.start_date between

Line 1612: FROM GL_LEDGERS ledger

1608:
1609: --Get ledger Name
1610: SELECT ledger.name
1611: INTO l_ledger_name
1612: FROM GL_LEDGERS ledger
1613: WHERE ledger.ledger_id = l_ledger_id
1614: ;
1615: /*FND_FILE.put_line(FND_FILE.output, '' ||l_LEDGER_name||'');*/
1616: -- sob name --> ledger name ,