APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_LEDGERS

Line 359: Gl_Ledgers Led

355: SELECT Fsav.Application_Column_Name
356: INTO l_Company_Column_Name
357: FROM Fnd_Id_Flex_Segments Fifs,
358: Fnd_Segment_Attribute_Values Fsav,
359: Gl_Ledgers Led
360: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
361: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
362: AND Fsav.Segment_Attribute_Type = 'GL_BALANCING'
363: AND Fsav.Attribute_Value = 'Y'

Line 391: ' ,gl_ledgers led' ||

387: ' FROM gl_je_headers jeh' ||
388: ' ,gl_je_lines jel' ||
389: ' ,gl_code_combinations gcc' ||
390: ' ,gl_periods gp' ||
391: ' ,gl_ledgers led' ||
392: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
393: ' WHERE jeh.je_header_id = jel.je_header_id' ||
394: ' AND jeh.status = ''P''' ||
395: ' AND jeh.period_name = gp.period_name' ||

Line 495: GL_LEDGERS LED

491: WHERE FLV.LOOKUP_TYPE = 'JA_CN_SUB_ACC_SEGMENT'
492: AND FLV.LANGUAGE = USERENV('LANG')
493: AND NOT EXISTS(
494: SELECT * FROM JA_CN_SUB_ACC_MAPPING SAM,
495: GL_LEDGERS LED
496: WHERE SAM.SOURCES_CODE = 'COA'
497: AND SAM.CHART_OF_ACCOUNTS_ID = LED.CHART_OF_ACCOUNTS_ID
498: AND LED.LEDGER_ID = l_Ledger_Id
499: AND SAM.SUBSIDIARY_SEGMENT_CODE = FLV.LOOKUP_CODE)

Line 504: GL_LEDGERS LED

500: UNION
501: SELECT SAM.CONTEXT_CODE,
502: SAM.SUBSIDIARY_SEGMENT_CODE
503: FROM JA_CN_SUB_ACC_MAPPING SAM,
504: GL_LEDGERS LED
505: WHERE SAM.SOURCES_CODE = 'COA'
506: AND SAM.CHART_OF_ACCOUNTS_ID = LED.CHART_OF_ACCOUNTS_ID
507: AND LED.LEDGER_ID = l_Ledger_Id;
508:

Line 514: from gl_ledgers led

510:
511: --Begin: Delete by Chaoqun for CNAOV2
512: /*cursor c_company_segment is
513: SELECT led.bal_seg_column_name
514: from gl_ledgers led
515: where Led.Ledger_Id = l_Ledger_Id;
516:
517: CURSOR c_Cost_Center IS
518: SELECT Fsav.Application_Column_Name

Line 521: Gl_Ledgers Led

517: CURSOR c_Cost_Center IS
518: SELECT Fsav.Application_Column_Name
519: FROM Fnd_Id_Flex_Segments Fifs,
520: Fnd_Segment_Attribute_Values Fsav,
521: Gl_Ledgers Led
522: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
523: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
524: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'
525: AND Fsav.Attribute_Value = 'Y'

Line 538: Gl_Ledgers Led

534: CURSOR c_Segements IS
535: SELECT Fsav.Application_Column_Name
536: FROM Fnd_Id_Flex_Segments Fifs,
537: Fnd_Segment_Attribute_Values Fsav,
538: Gl_Ledgers Led
539: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
540: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
541: AND Fsav.Segment_Attribute_Type = 'GL_GLOBAL'
542: AND Fsav.Attribute_Value = 'Y'

Line 569: from gl_ledgers led

565:
566: --get application column name of company segment
567: SELECT led.bal_seg_column_name
568: INTO l_Company_Column_Name
569: from gl_ledgers led
570: where Led.Ledger_Id = l_Ledger_Id;
571:
572: --get application column name of account segment
573: SELECT Fsav.Application_Column_Name

Line 577: Gl_Ledgers Led

573: SELECT Fsav.Application_Column_Name
574: INTO l_Account_Column_Name
575: FROM Fnd_Id_Flex_Segments Fifs,
576: Fnd_Segment_Attribute_Values Fsav,
577: Gl_Ledgers Led
578: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
579: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
580: AND Fsav.Segment_Attribute_Type = 'GL_ACCOUNT'
581: AND Fsav.Attribute_Value = 'Y'

Line 613: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||

609:
610:
611: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||
612: l_Create_View_Sql || ' from gl_code_combinations gcc,' ||
613: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||
614: ' = gcc.chart_of_accounts_id';
615: --Updated by Jianchao Chi for bug 12363301, Zero Downtime Patching can't use EXECUTE IMMEDIATE
616: --to create view, so replace it with AD_DLL.DO_DLL.
617: --EXECUTE IMMEDIATE l_Create_View_Sql;

Line 655: Gl_Ledgers Led

651: SELECT Fsav.Application_Column_Name
652: INTO l_Second_Track_Col_Name
653: FROM Fnd_Id_Flex_Segments Fifs,
654: Fnd_Segment_Attribute_Values Fsav,
655: Gl_Ledgers Led
656: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
657: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
658: AND Fsav.Segment_Attribute_Type = 'GL_SECONDARY_TRACKING'
659: AND Fsav.Attribute_Value = 'Y'

Line 696: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||

692: ' other_columns,';
693: --jogen
694: l_Create_View_Sql := l_Create_View_Sql ||
695: 'to_number(null) project_id from gl_code_combinations gcc,' ||
696: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||
697: ' = gcc.chart_of_accounts_id';
698:
699: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||
700: l_Create_View_Sql;

Line 778: FROM Gl_Periods Gp, Gl_Ledgers Led

774: l_ledger_id := p_ledger_id;
775: --get the first period of current led
776: SELECT Gp.Period_Name
777: INTO p_Start_Period_Name
778: FROM Gl_Periods Gp, Gl_Ledgers Led
779: WHERE Led.Ledger_Id = l_Ledger_Id
780: AND Led.Period_Set_Name = Gp.Period_Set_Name
781: AND Led.Accounted_Period_Type = Gp.Period_Type
782: AND Gp.Start_Date IN

Line 792: FROM Gl_Periods Gp, Gl_Ledgers Led

788: -- if parameter period is null then pick up last open period as end period
789: IF l_Period_Name IS NULL THEN
790: SELECT Gp.Period_Name
791: INTO p_End_Period_Name
792: FROM Gl_Periods Gp, Gl_Ledgers Led
793: WHERE Led.Ledger_Id = l_Ledger_Id
794: AND Led.Period_Set_Name = Gp.Period_Set_Name
795: AND Led.Accounted_Period_Type = Gp.Period_Type
796: AND Gp.Start_Date IN

Line 1984: FROM Gl_Periods Gp, Gl_Ledgers Led

1980: --End: Chaoqun updateed for CNAOV2 on 01-20-2010
1981:
1982: CURSOR c_Period_Name IS
1983: SELECT Gp.Period_Name
1984: FROM Gl_Periods Gp, Gl_Ledgers Led
1985: WHERE Led.Ledger_Id = l_Ledger_Id
1986: AND Led.Period_Set_Name = Gp.Period_Set_Name
1987: AND Led.Accounted_Period_Type = Gp.Period_Type
1988: AND Gp.Start_Date BETWEEN