APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on GL_LEDGERS

Line 339: Gl_Ledgers Led

335: SELECT Fsav.Application_Column_Name
336: INTO l_Company_Column_Name
337: FROM Fnd_Id_Flex_Segments Fifs,
338: Fnd_Segment_Attribute_Values Fsav,
339: Gl_Ledgers Led
340: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
341: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
342: AND Fsav.Segment_Attribute_Type = 'GL_BALANCING'
343: AND Fsav.Attribute_Value = 'Y'

Line 371: ' ,gl_ledgers led' ||

367: ' FROM gl_je_headers jeh' ||
368: ' ,gl_je_lines jel' ||
369: ' ,gl_code_combinations gcc' ||
370: ' ,gl_periods gp' ||
371: ' ,gl_ledgers led' ||
372: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
373: ' WHERE jeh.je_header_id = jel.je_header_id' ||
374: ' AND jeh.status = ''P''' ||
375: ' AND jeh.period_name = gp.period_name' ||

Line 464: from gl_ledgers led

460: l_ledger_id number;
461:
462: cursor c_company_segment is
463: SELECT led.bal_seg_column_name
464: from gl_ledgers led
465: where Led.Ledger_Id = l_Ledger_Id;
466:
467: CURSOR c_Cost_Center IS
468: SELECT Fsav.Application_Column_Name

Line 471: Gl_Ledgers Led

467: CURSOR c_Cost_Center IS
468: SELECT Fsav.Application_Column_Name
469: FROM Fnd_Id_Flex_Segments Fifs,
470: Fnd_Segment_Attribute_Values Fsav,
471: Gl_Ledgers Led
472: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
473: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
474: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'
475: AND Fsav.Attribute_Value = 'Y'

Line 488: Gl_Ledgers Led

484: CURSOR c_Segements IS
485: SELECT Fsav.Application_Column_Name
486: FROM Fnd_Id_Flex_Segments Fifs,
487: Fnd_Segment_Attribute_Values Fsav,
488: Gl_Ledgers Led
489: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
490: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
491: AND Fsav.Segment_Attribute_Type = 'GL_GLOBAL'
492: AND Fsav.Attribute_Value = 'Y'

Line 513: from gl_ledgers led

509: l_ledger_id := p_ledger_id;
510: --get application column name of company segment
511: SELECT led.bal_seg_column_name
512: INTO l_Company_Column_Name
513: from gl_ledgers led
514: where Led.Ledger_Id = l_Ledger_Id;
515:
516: --get application column name of account segment
517: SELECT Fsav.Application_Column_Name

Line 521: Gl_Ledgers Led

517: SELECT Fsav.Application_Column_Name
518: INTO l_Account_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 = 'GL_ACCOUNT'
525: AND Fsav.Attribute_Value = 'Y'

Line 572: Gl_Ledgers Led

568: SELECT Fsav.Application_Column_Name
569: INTO l_Second_Track_Col_Name
570: FROM Fnd_Id_Flex_Segments Fifs,
571: Fnd_Segment_Attribute_Values Fsav,
572: Gl_Ledgers Led
573: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
574: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
575: AND Fsav.Segment_Attribute_Type = 'GL_SECONDARY_TRACKING'
576: AND Fsav.Attribute_Value = 'Y'

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

609: ' other_columns,';
610: --jogen
611: l_Create_View_Sql := l_Create_View_Sql ||
612: 'to_number(null) project_id from gl_code_combinations gcc,' ||
613: ' GL_LEDGERS led where led.chart_of_accounts_id ' ||
614: ' = gcc.chart_of_accounts_id';
615:
616: l_Create_View_Sql := 'create or replace view ja_cn_code_combination_v as ' ||
617: l_Create_View_Sql;

Line 692: FROM Gl_Periods Gp, Gl_Ledgers Led

688: l_ledger_id := p_ledger_id;
689: --get the first period of current led
690: SELECT Gp.Period_Name
691: INTO p_Start_Period_Name
692: FROM Gl_Periods Gp, Gl_Ledgers Led
693: WHERE Led.Ledger_Id = l_Ledger_Id
694: AND Led.Period_Set_Name = Gp.Period_Set_Name
695: AND Led.Accounted_Period_Type = Gp.Period_Type
696: AND Gp.Start_Date IN

Line 706: FROM Gl_Periods Gp, Gl_Ledgers Led

702: -- if parameter period is null then pick up last open period as end period
703: IF l_Period_Name IS NULL THEN
704: SELECT Gp.Period_Name
705: INTO p_End_Period_Name
706: FROM Gl_Periods Gp, Gl_Ledgers Led
707: WHERE Led.Ledger_Id = l_Ledger_Id
708: AND Led.Period_Set_Name = Gp.Period_Set_Name
709: AND Led.Accounted_Period_Type = Gp.Period_Type
710: AND Gp.Start_Date IN

Line 1549: FROM Gl_Periods Gp, Gl_Ledgers Led

1545: WHERE Chart_Of_Accounts_Id = l_Chart_Of_Accounts_Id;
1546:
1547: CURSOR c_Period_Name IS
1548: SELECT Gp.Period_Name
1549: FROM Gl_Periods Gp, Gl_Ledgers Led
1550: WHERE Led.Ledger_Id = l_Ledger_Id
1551: AND Led.Period_Set_Name = Gp.Period_Set_Name
1552: AND Led.Accounted_Period_Type = Gp.Period_Type
1553: AND Gp.Start_Date BETWEEN