DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on GL_PERIODS

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 1709: Gl_Periods Gp

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
1713: AND Gp.period_name = pv_period_name) --parameter: pv_period_name

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 2248: Gl_Periods Gp,

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
2252: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 2266: FROM Gl_Periods Gp1

2262: AND Gl.accounted_period_type = Gp.period_type
2263: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
2264: AND Gp.start_date BETWEEN
2265: (SELECT Gp1.Start_Date
2266: FROM Gl_Periods Gp1
2267: WHERE Gl.period_set_name = Gp1.period_set_name
2268: AND Gl.accounted_period_type = Gp1.period_type
2269: AND Gp1.period_name = pv_first_period) --parameter: pv_first_period
2270: AND (SELECT Gp2.Start_Date

Line 2271: FROM Gl_Periods Gp2

2267: WHERE Gl.period_set_name = Gp1.period_set_name
2268: AND Gl.accounted_period_type = Gp1.period_type
2269: AND Gp1.period_name = pv_first_period) --parameter: pv_first_period
2270: AND (SELECT Gp2.Start_Date
2271: FROM Gl_Periods Gp2
2272: WHERE Gl.period_set_name = Gp2.period_set_name
2273: AND Gl.accounted_period_type = Gp2.period_type
2274: AND Gp2.period_name = pv_first_period) --parameter: pv_first_period
2275: --SLA condition

Line 2657: Gl_Periods Gp,

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,
2661: Fnd_Currencies_Vl Fcv

Line 2676: FROM Gl_Periods Gp1

2672: AND Gl.accounted_period_type = Gp.period_type
2673: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
2674: AND Gp.start_date BETWEEN
2675: (SELECT Gp1.Start_Date
2676: FROM Gl_Periods Gp1
2677: WHERE Gl.period_set_name = Gp1.period_set_name
2678: AND Gl.accounted_period_type = Gp1.period_type
2679: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
2680: AND (SELECT Gp2.Start_Date

Line 2681: FROM Gl_Periods Gp2

2677: WHERE Gl.period_set_name = Gp1.period_set_name
2678: AND Gl.accounted_period_type = Gp1.period_type
2679: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
2680: AND (SELECT Gp2.Start_Date
2681: FROM Gl_Periods Gp2
2682: WHERE Gl.period_set_name = Gp2.period_set_name
2683: AND Gl.accounted_period_type = Gp2.period_type
2684: AND Gp2.period_name = pv_period_to) --parameter: pv_period_to
2685: --SLA condition

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 2759: Gl_Periods Gp

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
2763: AND Gl.accounted_period_type = Gp.period_type

Line 2767: FROM Gl_Periods Gp1

2763: AND Gl.accounted_period_type = Gp.period_type
2764: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
2765: AND Gp.start_date BETWEEN
2766: (SELECT Gp1.Start_Date
2767: FROM Gl_Periods Gp1
2768: WHERE Gl.period_set_name = Gp1.period_set_name
2769: AND Gl.accounted_period_type = Gp1.period_type
2770: AND Gp1.period_name = lv_inv_period_name) --variable: lv_inv_period_name
2771: AND (SELECT Gp2.Start_Date

Line 2772: FROM Gl_Periods Gp2

2768: WHERE Gl.period_set_name = Gp1.period_set_name
2769: AND Gl.accounted_period_type = Gp1.period_type
2770: AND Gp1.period_name = lv_inv_period_name) --variable: lv_inv_period_name
2771: AND (SELECT Gp2.Start_Date
2772: FROM Gl_Periods Gp2
2773: WHERE Gl.period_set_name = Gp2.period_set_name
2774: AND Gl.accounted_period_type = Gp2.period_type
2775: AND Gp2.period_name = pv_period_to) --parameter: pv_period_to
2776: ORDER BY Gp.Start_Date;

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 3065: FROM Gl_Periods Gp1

3061: AND Gl.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
3062: AND Gp.Period_Name = pv_period_from --parameter: pv_period_from
3063: AND Gp.Start_Date =
3064: (SELECT MIN(Gp1.START_DATE)
3065: FROM Gl_Periods Gp1
3066: WHERE Gl.period_set_name = Gp1.period_set_name
3067: AND Gl.accounted_period_type = Gp1.period_type
3068: AND Gp1.period_year = Gp.period_year);
3069: IF lv_first_period_flag = 'Y' THEN

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 3080: FROM Gl_Periods Gp1

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
3078: AND Gp.Start_Date =
3079: (SELECT MIN(Gp1.START_DATE)
3080: FROM Gl_Periods Gp1
3081: WHERE Gl.period_set_name = Gp1.period_set_name
3082: AND Gl.accounted_period_type = Gp1.period_type
3083: AND Gp1.period_year = Gp.period_year);
3084: EXCEPTION

Line 3157: Gl_Periods Gp

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
3161: AND Gl.accounted_period_type = Gp.period_type

Line 3702: Gl_Periods Gp

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
3706: AND Gl.accounted_period_type = Gp.period_type