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_ACC_JE_ITEMIZATION_PKG dependencies on GL_PERIODS

Line 87: l_Period_Name Gl_Periods.Period_Name%TYPE;

83: PROCEDURE Get_Journal_Approver(p_Request_Id IN NUMBER) IS
84: l_Request_Id NUMBER := p_Request_Id;
85: l_Je_Header_Id NUMBER;
86: l_Batch_Name Gl_Je_Batches.NAME%TYPE;
87: l_Period_Name Gl_Periods.Period_Name%TYPE;
88: l_Approver VARCHAR2(100);
89: l_Approval_Status VARCHAR2(1);
90: l_Approver_Name VARCHAR2(100);
91: l_Step VARCHAR2(100);

Line 390: ' ,gl_periods gp' ||

386: ',jeh.default_effective_date ' ||
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''' ||

Line 404: ' FROM gl_periods' ||

400: ' AND bsv.legal_entity_id = ' ||
401: l_Legal_Entity_Id ||
402: ' AND gp.start_date BETWEEN' ||
403: ' (SELECT start_date' ||
404: ' FROM gl_periods' ||
405: ' WHERE period_name =''' ||
406: l_Start_Period || '''' ||
407: ' AND period_set_name = led.period_set_name)' ||
408: ' AND (SELECT start_date' ||

Line 409: ' FROM gl_periods' ||

405: ' WHERE period_name =''' ||
406: l_Start_Period || '''' ||
407: ' AND period_set_name = led.period_set_name)' ||
408: ' AND (SELECT start_date' ||
409: ' FROM gl_periods' ||
410: ' WHERE period_name =''' ||
411: l_End_Period || '''' ||
412: ' AND period_set_name = led.period_set_name)' ||
413: ' AND gp.period_set_name = led.period_set_name' ||

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 784: FROM Gl_Periods Gp

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
783: (SELECT MIN(Start_Date)
784: FROM Gl_Periods Gp
785: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
786: AND Led.Accounted_Period_Type = Gp.Period_Type);
787:
788: -- if parameter period is null then pick up last open period as end period

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 798: FROM Gl_Periods Gp

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
797: (SELECT MAX(Start_Date)
798: FROM Gl_Periods Gp
799: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
800: AND Led.Accounted_Period_Type = Gp.Period_Type);
801: ELSE
802: p_End_Period_Name := l_Period_Name;

Line 1301: l_Period_Name Gl_Periods.Period_Name%TYPE;

1297: p_Request_Id IN NUMBER,
1298: p_ledger_id in number,
1299: P_legal_entity_id in number) IS
1300: l_Request_Id NUMBER;
1301: l_Period_Name Gl_Periods.Period_Name%TYPE;
1302: l_Je_Header_Id NUMBER;
1303: l_Journal_Number NUMBER;
1304: l_Je_Appending_Id NUMBER;
1305: l_Line_Num_m NUMBER;

Line 1943: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;

1939: l_Status VARCHAR2(100);
1940: l_Dev_Phase VARCHAR2(100);
1941: l_Dev_Status VARCHAR2(100);
1942: l_Message VARCHAR2(100);
1943: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1944: l_Period_Name Gl_Periods.Period_Name%TYPE;
1945: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1946: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1947: l_Conc_Succ BOOLEAN;

Line 1944: l_Period_Name Gl_Periods.Period_Name%TYPE;

1940: l_Dev_Phase VARCHAR2(100);
1941: l_Dev_Status VARCHAR2(100);
1942: l_Message VARCHAR2(100);
1943: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1944: l_Period_Name Gl_Periods.Period_Name%TYPE;
1945: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1946: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1947: l_Conc_Succ BOOLEAN;
1948: l_Request_Id NUMBER;

Line 1945: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;

1941: l_Dev_Status VARCHAR2(100);
1942: l_Message VARCHAR2(100);
1943: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1944: l_Period_Name Gl_Periods.Period_Name%TYPE;
1945: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1946: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1947: l_Conc_Succ BOOLEAN;
1948: l_Request_Id NUMBER;
1949: l_Chart_Of_Account_Id NUMBER;

Line 1946: l_End_Period_Name Gl_Periods.Period_Name%TYPE;

1942: l_Message VARCHAR2(100);
1943: l_Till_Period_Name Gl_Periods.Period_Name%TYPE;
1944: l_Period_Name Gl_Periods.Period_Name%TYPE;
1945: l_Start_Period_Name Gl_Periods.Period_Name%TYPE;
1946: l_End_Period_Name Gl_Periods.Period_Name%TYPE;
1947: l_Conc_Succ BOOLEAN;
1948: l_Request_Id NUMBER;
1949: l_Chart_Of_Account_Id NUMBER;
1950: l_Ledger_Id NUMBER;

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

Line 1990: FROM Gl_Periods Gp

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
1989: (SELECT Start_Date
1990: FROM Gl_Periods Gp
1991: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1992: AND Led.Accounted_Period_Type = Gp.Period_Type
1993: AND Gp.Period_Name = l_Start_Period_Name)
1994: AND (SELECT Start_Date

Line 1995: FROM Gl_Periods Gp

1991: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1992: AND Led.Accounted_Period_Type = Gp.Period_Type
1993: AND Gp.Period_Name = l_Start_Period_Name)
1994: AND (SELECT Start_Date
1995: FROM Gl_Periods Gp
1996: WHERE Led.Period_Set_Name = Gp.Period_Set_Name
1997: AND Led.Accounted_Period_Type = Gp.Period_Type
1998: AND Gp.Period_Name = l_End_Period_Name)
1999: ORDER BY Gp.Start_Date;