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_AP_PBD_EXPORT_PKG dependencies on GL_LEDGERS

Line 670: FROM Gl_Periods Gp, Gl_Ledgers Gl

666: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
667:
668: CURSOR period_num_cur(lv_period_name VARCHAR2) IS
669: SELECT TO_CHAR(Gp.Period_Num)
670: FROM Gl_Periods Gp, Gl_Ledgers Gl
671: WHERE Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
672: AND Gl.period_set_name = Gp.period_set_name
673: AND Gl.accounted_period_type = Gp.period_type
674: AND Gp.Period_Name = lv_period_name; --variable: lv_period_name

Line 1708: FROM Gl_Ledgers Gl,

1704: WHERE Aia.Invoice_Id = Aip.Invoice_Id
1705: AND Ach.Check_Id = Aip.Check_Id
1706: AND Aia.Invoice_Id = pn_invoice_id -- parameter: pn_invoice_id
1707: AND Aip.Accounting_Date <= (SELECT DISTINCT Gp.End_Date
1708: FROM Gl_Ledgers Gl,
1709: Gl_Periods Gp
1710: WHERE Gl.period_set_name = Gp.period_set_name
1711: AND Gl.accounted_period_type = Gp.period_type
1712: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 1748: FROM Gl_Ledgers Gl, Gl_Periods Gp

1744: Gl_Import_References Gir
1745: WHERE Ach.Check_Id = Aip.Check_Id
1746: AND Aip.Accounting_Date <=
1747: (SELECT DISTINCT Gp.End_Date
1748: FROM Gl_Ledgers Gl, Gl_Periods Gp
1749: WHERE Gl.period_set_name = Gp.period_set_name
1750: AND Gl.accounted_period_type = Gp.period_type
1751: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1752: AND Gp.period_name = pv_period_name) --parameter: pv_period_name

Line 1756: FROM Gl_Ledgers Gl, Gl_Periods Gp

1752: AND Gp.period_name = pv_period_name) --parameter: pv_period_name
1753: -- Choli updated, fix bug 12635156
1754: AND Ach.cleared_date <=
1755: (SELECT DISTINCT Gp.End_Date
1756: FROM Gl_Ledgers Gl, Gl_Periods Gp
1757: WHERE Gl.period_set_name = Gp.period_set_name
1758: AND Gl.accounted_period_type = Gp.period_type
1759: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1760: AND Gp.period_name = pv_period_name) --parameter: pv_period_name

Line 1805: FROM Gl_Ledgers Gl, Gl_Periods Gp

1801: AND Jeh.Status = 'P' --only collecting posted prepayment application
1802: --Period condition
1803: AND Jeh.Default_Effective_Date <=
1804: (SELECT DISTINCT Gp.End_Date
1805: FROM Gl_Ledgers Gl, Gl_Periods Gp
1806: WHERE Gl.period_set_name = Gp.period_set_name
1807: AND Gl.accounted_period_type = Gp.period_type
1808: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1809: AND Gp.period_name = pv_period_name) --parameter: pv_period_name

Line 1948: FROM Gl_Ledgers Gl, Gl_Periods Gp

1944: AND Jeh.Status = 'P' --only collecting posted prepayment application
1945: --Period condition
1946: AND Jeh.Default_Effective_Date <=
1947: (SELECT DISTINCT Gp.End_Date
1948: FROM Gl_Ledgers Gl, Gl_Periods Gp
1949: WHERE Gl.period_set_name = Gp.period_set_name
1950: AND Gl.accounted_period_type = Gp.period_type
1951: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1952: AND Gp.period_name = pv_period_name) --parameter: pv_period_name

Line 2247: Gl_Ledgers Gl,

2243: FROM Gl_Je_Lines Jel,
2244: Gl_Je_Headers Jeh,
2245: Gl_Import_References Gir,
2246: Ja_Cn_Code_Combination_v Jcc,
2247: Gl_Ledgers Gl,
2248: Gl_Periods Gp,
2249: Xla_Ae_Lines Ael,
2250: Xla_Ae_Headers Aeh,
2251: Ap_Suppliers Sup

Line 2305: FROM Gl_Ledgers Gl, Fnd_Currencies_Vl Fcv

2301:
2302: BEGIN
2303: SELECT Fcv.NAME Functional_Currency
2304: INTO lv_fun_currency
2305: FROM Gl_Ledgers Gl, Fnd_Currencies_Vl Fcv
2306: WHERE Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2307: AND Fcv.CURRENCY_CODE = Gl.Currency_Code;
2308: EXCEPTION
2309: WHEN NO_DATA_FOUND THEN

Line 2656: Gl_Ledgers Gl,

2652: FROM Gl_Je_Lines Jel,
2653: Gl_Je_Headers Jeh,
2654: Gl_Import_References Gir,
2655: Ja_Cn_Code_Combination_v Jcc,
2656: Gl_Ledgers Gl,
2657: Gl_Periods Gp,
2658: Xla_Ae_Lines Ael,
2659: Xla_Ae_Headers Aeh,
2660: Ap_Suppliers Sup,

Line 2733: FROM Gl_Periods Gp1, Gl_Ledgers Gl

2729: AND Aeh.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2730: --Period condition
2731: AND Aia.Gl_Date NOT BETWEEN
2732: (SELECT Gp1.Start_Date
2733: FROM Gl_Periods Gp1, Gl_Ledgers Gl
2734: WHERE Gl.period_set_name = Gp1.period_set_name
2735: AND Gl.accounted_period_type = Gp1.period_type
2736: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2737: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from

Line 2739: FROM Gl_Periods Gp2, Gl_Ledgers Gl

2735: AND Gl.accounted_period_type = Gp1.period_type
2736: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2737: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
2738: AND (SELECT Gp2.End_Date
2739: FROM Gl_Periods Gp2, Gl_Ledgers Gl
2740: WHERE Gl.period_set_name = Gp2.period_set_name
2741: AND Gl.accounted_period_type = Gp2.period_type
2742: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2743: AND Gp2.period_name = pv_period_to); --parameter: pv_period_to

Line 2758: Gl_Ledgers Gl,

2754: WHERE Aia.Invoice_Id = Aip.Invoice_Id
2755: AND Aia.Invoice_Id = ln_invoice_id --variable: ln_invoice_id
2756: ) Ppn --period name for payables
2757: ,
2758: Gl_Ledgers Gl,
2759: Gl_Periods Gp
2760: WHERE Ppn.Period_Name = Gp.Period_Name
2761: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id --Fix bug 10008055
2762: AND Gl.period_set_name = Gp.period_set_name

Line 3057: FROM Gl_Ledgers Gl, Gl_Periods Gp

3053: 0,
3054: 'N', --Not first period, in this case, year begnning balance would not be exported
3055: 'Y') --It is first period and year beginning balance should be exported
3056: INTO lv_first_period_flag
3057: FROM Gl_Ledgers Gl, Gl_Periods Gp
3058: WHERE Gl.period_set_name = Gp.period_set_name
3059: AND Gl.accounted_period_type = Gp.period_type
3060: AND Gp.period_year = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
3061: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 3073: FROM Gl_Ledgers Gl, Gl_Periods Gp

3069: IF lv_first_period_flag = 'Y' THEN
3070: BEGIN
3071: SELECT Gp.Period_Name, Gp.Period_Num
3072: INTO lv_first_period_name, ln_first_period_num
3073: FROM Gl_Ledgers Gl, Gl_Periods Gp
3074: WHERE Gl.period_set_name = Gp.period_set_name
3075: AND Gl.accounted_period_type = Gp.period_type
3076: AND Gp.period_year = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
3077: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id

Line 3156: Gl_Ledgers Gl,

3152: --Else they are in different accounting periods
3153: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
3154: INTO lv_inv_prepay_same_period_flag
3155: FROM Ap_Prepay_History_All Aph,
3156: Gl_Ledgers Gl,
3157: Gl_Periods Gp
3158: WHERE Prepay_Invoice_Id = v_inv_id_row.Invoice_Id --Updated for fixing bug# 9747676
3159: AND Accounting_Date BETWEEN Gp.Start_Date AND Gp.End_Date
3160: AND Gl.period_set_name = Gp.period_set_name

Line 3701: Gl_Ledgers Gl,

3697: --Else they are in different accounting periods
3698: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
3699: INTO lv_inv_prepay_same_period_flag
3700: FROM Ap_Prepay_History_All Aph,
3701: Gl_Ledgers Gl,
3702: Gl_Periods Gp
3703: WHERE Invoice_Id = v_inv_id_row.Invoice_Id
3704: AND Accounting_Date BETWEEN Gp.Start_Date AND Gp.End_Date
3705: AND Gl.period_set_name = Gp.period_set_name