APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 1924: FROM Ap_Prepay_History_All Aph,

1920:
1921: CURSOR applied_amount_cur IS
1922: --collecting applied amount
1923: SELECT SUM(-1 * NVL(Ael.Entered_Dr, 0) + NVL(Ael.Entered_Cr, 0)) Applied_Amount
1924: FROM Ap_Prepay_History_All Aph,
1925: Xla_Ae_Headers Aeh,
1926: Xla_Ae_Lines Ael,
1927: Ja_Cn_Code_Combination_v Jcc,
1928: Gl_Je_Headers Jeh,

Line 3012: FROM Ap_Prepay_History_All Aph, Xla_Ae_Headers Aeh

3008:
3009: --Cursor for fetching prepaid invoice id
3010: CURSOR prepay_inv_id_cur(ln_invoice_id NUMBER, ln_ae_header_id NUMBER) IS
3011: SELECT Aph.Prepay_Invoice_Id
3012: FROM Ap_Prepay_History_All Aph, Xla_Ae_Headers Aeh
3013: WHERE Aph.Invoice_Id = ln_invoice_id --variable: ln_invoice_id
3014: AND Aph.Accounting_Event_Id = Aeh.Event_Id
3015: AND Aeh.Ae_Header_Id = ln_ae_header_id; --variable: ln_ae_header_id
3016:

Line 3155: FROM Ap_Prepay_History_All Aph,

3151: --in this case, prepaid line for prepayment invoice would not be exported again,
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

Line 3700: FROM Ap_Prepay_History_All Aph,

3696: --in this case, invoice line for invoice would not be exported again,
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