APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_LEDGERS

Line 159: ,GL_LEDGERS ledger

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

Line 494: ,GL_LEDGERS ledger

490: ,FFV.Flex_Value flex_value
491: ,FFVT.Description flex_desc
492: BULK COLLECT INTO l_all_acc_seg
493: FROM GL_CODE_COMBINATIONS gcc
494: ,GL_LEDGERS ledger
495: ,FND_ID_FLEX_SEGMENTS FIFS
496: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
497: ,FND_FLEX_VALUE_SETS FFVS
498: ,FND_FLEX_VALUES FFV

Line 698: FROM gl_periods gp, GL_LEDGERS ledger

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

Line 938: FROM GL_LEDGERS ledger

934:
935: --Get ledger Name
936: SELECT ledger.name
937: INTO l_ledger_name
938: FROM GL_LEDGERS ledger
939: WHERE ledger.ledger_id = l_ledger_id
940: ;
941: -- FND_FILE.put_line(FND_FILE.output, '' ||l_sob_name||'');
942: SELECT XMLELEMENT( "LEDGER_NAME",l_ledger_name ) INTO l_xml_item FROM dual;

Line 1416: FROM gl_periods gp, GL_LEDGERS ledger

1412: , gp.period_year
1413: , gp.period_num
1414: , gp.start_date
1415: , gp.end_date
1416: FROM gl_periods gp, GL_LEDGERS ledger
1417: WHERE ledger.ledger_id = l_ledger_id --using variable l_ledger_id
1418: AND ledger.period_set_name = GP.PERIOD_SET_NAME
1419: AND ledger.accounted_period_type = gp.period_type
1420: AND gp.start_date between

Line 1649: FROM GL_LEDGERS ledger

1645:
1646: --Get ledger Name
1647: SELECT ledger.name
1648: INTO l_ledger_name
1649: FROM GL_LEDGERS ledger
1650: WHERE ledger.ledger_id = l_ledger_id
1651: ;
1652: /*FND_FILE.put_line(FND_FILE.output, '' ||l_LEDGER_name||'');*/
1653: -- sob name --> ledger name ,