eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on GL_PERIODS

Line 1121: FROM Gl_Periods Gp, Gl_Ledgers Led

1117: where --legal_entity_id = P_LEGAL_ENTITY_ID and--this condition will be put the legal_consistent validation
1118: ledger_id = P_LEDGER_ID
1119: and period_name in(
1120: SELECT Gp.Period_Name
1121: FROM Gl_Periods Gp, Gl_Ledgers Led
1122: WHERE Led.Ledger_Id = p_Ledger_Id
1123: AND Led.Period_Set_Name = Gp.Period_Set_Name
1124: AND Led.Accounted_Period_Type = Gp.Period_Type
1125: AND Gp.Start_Date BETWEEN

Line 1127: FROM Gl_Periods Gp

1123: AND Led.Period_Set_Name = Gp.Period_Set_Name
1124: AND Led.Accounted_Period_Type = Gp.Period_Type
1125: AND Gp.Start_Date BETWEEN
1126: (SELECT Start_Date
1127: FROM Gl_Periods Gp
1128: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1129: AND Led.Accounted_Period_Type = Gp.Period_Type
1130: AND Gp.Period_Name = P_PERIOD_FROM )
1131: AND (SELECT Start_Date

Line 1132: FROM Gl_Periods Gp

1128: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1129: AND Led.Accounted_Period_Type = Gp.Period_Type
1130: AND Gp.Period_Name = P_PERIOD_FROM )
1131: AND (SELECT Start_Date
1132: FROM Gl_Periods Gp
1133: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1134: AND Led.Accounted_Period_Type = Gp.Period_Type
1135: AND Gp.Period_Name = P_PERIOD_TO)
1136: );

Line 1298: ' ,gl_periods gp' ||

1294: -- ',jeh.default_effective_date ' ||
1295: ' FROM gl_je_headers jeh' ||
1296: ' ,gl_je_lines jel' ||
1297: ' ,gl_code_combinations gcc' ||
1298: ' ,gl_periods gp' ||
1299: ' ,gl_ledgers led' ||
1300: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
1301: ' WHERE jeh.je_header_id = jel.je_header_id' ||
1302: ' AND jeh.status = ''P''' ||

Line 1312: ' FROM gl_periods' ||

1308: ' AND bsv.legal_entity_id = ' ||
1309: l_Legal_Entity_Id ||
1310: ' AND gp.start_date BETWEEN' ||
1311: ' (SELECT start_date' ||
1312: ' FROM gl_periods' ||
1313: ' WHERE period_name =''' ||
1314: l_Start_Period || '''' ||
1315: ' AND period_set_name = led.period_set_name)' ||
1316: ' AND (SELECT start_date' ||

Line 1317: ' FROM gl_periods' ||

1313: ' WHERE period_name =''' ||
1314: l_Start_Period || '''' ||
1315: ' AND period_set_name = led.period_set_name)' ||
1316: ' AND (SELECT start_date' ||
1317: ' FROM gl_periods' ||
1318: ' WHERE period_name =''' ||
1319: l_End_Period || '''' ||
1320: ' AND period_set_name = led.period_set_name)' ||
1321: ' AND gp.period_set_name = led.period_set_name' ||

Line 1377: l_Period_Name Gl_Periods.Period_Name%TYPE;

1373:
1374: PROCEDURE Generate_Journal_Num( p_period_Name IN VARCHAR2,
1375: p_ledger_id in number,
1376: P_legal_entity_id in number) IS
1377: l_Period_Name Gl_Periods.Period_Name%TYPE;
1378: l_Je_Header_Id NUMBER;
1379: l_Journal_Number NUMBER;
1380: l_Je_Appending_Id NUMBER;
1381:

Line 1778: FROM Gl_Periods Gp, Gl_Ledgers Led

1774: AND LEDGER_ID = p_ledger_id
1775: AND STATUS IS NOT NULL
1776: AND period_name in(
1777: SELECT Gp.Period_Name
1778: FROM Gl_Periods Gp, Gl_Ledgers Led
1779: WHERE Led.Ledger_Id = p_Ledger_Id
1780: AND Led.Period_Set_Name = Gp.Period_Set_Name
1781: AND Led.Accounted_Period_Type = Gp.Period_Type
1782: AND Gp.Start_Date BETWEEN

Line 1784: FROM Gl_Periods Gp

1780: AND Led.Period_Set_Name = Gp.Period_Set_Name
1781: AND Led.Accounted_Period_Type = Gp.Period_Type
1782: AND Gp.Start_Date BETWEEN
1783: (SELECT Start_Date
1784: FROM Gl_Periods Gp
1785: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1786: AND Led.Accounted_Period_Type = Gp.Period_Type
1787: AND Gp.Period_Name = L_PERIOD_FROM )
1788: AND (SELECT Start_Date

Line 1789: FROM Gl_Periods Gp

1785: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1786: AND Led.Accounted_Period_Type = Gp.Period_Type
1787: AND Gp.Period_Name = L_PERIOD_FROM )
1788: AND (SELECT Start_Date
1789: FROM Gl_Periods Gp
1790: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1791: AND Led.Accounted_Period_Type = Gp.Period_Type
1792: AND Gp.Period_Name = P_PERIOD_TO)
1793: )

Line 1826: FROM Gl_Periods Gp, Gl_Ledgers Led

1822: if P_PERIOD_FROM is null then
1823: --get the first period of current led
1824: SELECT Gp.Period_Name
1825: INTO l_period_from
1826: FROM Gl_Periods Gp, Gl_Ledgers Led
1827: WHERE Led.Ledger_Id = p_ledger_id
1828: AND Led.Period_Set_Name = Gp.Period_Set_Name
1829: AND Led.Accounted_Period_Type = Gp.Period_Type
1830: AND Gp.Start_Date IN

Line 1832: FROM Gl_Periods Gp

1828: AND Led.Period_Set_Name = Gp.Period_Set_Name
1829: AND Led.Accounted_Period_Type = Gp.Period_Type
1830: AND Gp.Start_Date IN
1831: (SELECT MIN(Start_Date)
1832: FROM Gl_Periods Gp
1833: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1834: AND Led.Accounted_Period_Type = Gp.Period_Type);
1835: end if;
1836:

Line 1990: FROM Gl_Periods Gp, Gl_Ledgers Led

1986: where status='U';
1987:
1988: CURSOR c_Period_Name IS
1989: SELECT Gp.Period_Name
1990: FROM Gl_Periods Gp, Gl_Ledgers Led
1991: WHERE Led.Ledger_Id = l_Ledger_Id
1992: AND Led.Period_Set_Name = Gp.Period_Set_Name
1993: AND Led.Accounted_Period_Type = Gp.Period_Type
1994: AND Gp.Start_Date BETWEEN

Line 1996: FROM Gl_Periods Gp

1992: AND Led.Period_Set_Name = Gp.Period_Set_Name
1993: AND Led.Accounted_Period_Type = Gp.Period_Type
1994: AND Gp.Start_Date BETWEEN
1995: (SELECT Start_Date
1996: FROM Gl_Periods Gp
1997: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1998: AND Led.Accounted_Period_Type = Gp.Period_Type
1999: AND Gp.Period_Name = l_period_from )
2000: AND (SELECT Start_Date

Line 2001: FROM Gl_Periods Gp

1997: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1998: AND Led.Accounted_Period_Type = Gp.Period_Type
1999: AND Gp.Period_Name = l_period_from )
2000: AND (SELECT Start_Date
2001: FROM Gl_Periods Gp
2002: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
2003: AND Led.Accounted_Period_Type = Gp.Period_Type
2004: AND Gp.Period_Name = l_period_to)
2005: ORDER BY Gp.Start_Date;

Line 2082: FROM Gl_Periods Gp, Gl_Ledgers Led

2078: if P_PERIOD_FROM is null then
2079: --get the first period of current led
2080: SELECT Gp.Period_Name
2081: INTO l_period_from
2082: FROM Gl_Periods Gp, Gl_Ledgers Led
2083: WHERE Led.Ledger_Id = l_ledger_id
2084: AND Led.Period_Set_Name = Gp.Period_Set_Name
2085: AND Led.Accounted_Period_Type = Gp.Period_Type
2086: AND Gp.Start_Date IN

Line 2088: FROM Gl_Periods Gp

2084: AND Led.Period_Set_Name = Gp.Period_Set_Name
2085: AND Led.Accounted_Period_Type = Gp.Period_Type
2086: AND Gp.Start_Date IN
2087: (SELECT MIN(Start_Date)
2088: FROM Gl_Periods Gp
2089: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
2090: AND Led.Accounted_Period_Type = Gp.Period_Type);
2091: end if;
2092: