DBA Data[Home] [Help]

APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_PREPAY_HISTORY_ALL

Line 51: FROM AP_Prepay_History_All APH,

47: APH.Transaction_Type,
48: APH.Accounting_Date,
49: APH.Invoice_Adjustment_Event_ID,
50: APH.Related_Prepay_App_Event_ID
51: FROM AP_Prepay_History_All APH,
52: XLA_Events XE
53: WHERE APH.Invoice_ID = P_Invoice_ID
54: --AND APH.Accounting_Event_ID IS NULL
55: AND nvl(APH.Posted_flag, 'N') <> 'Y'

Line 93: FROM AP_Prepay_History_All APH,

89: --AND Accounting_Event_ID IS NULL
90: AND nvl(AID.Posted_flag, 'N') <> 'Y'
91: AND nvl(AID.Encumbered_flag, 'N') <> 'Y'
92: AND EXISTS (SELECT 'Prepay History'
93: FROM AP_Prepay_History_All APH,
94: AP_Invoice_Distributions_All AID1
95: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
96: AND AID1.Invoice_Distribution_ID = AID.Prepay_Distribution_ID
97: AND AID1.Invoice_ID = APH.Prepay_Invoice_ID

Line 127: FROM AP_Prepay_History_All APH,

123: AND Line_Type_Lookup_Code = 'PREPAY'
124: AND Accounting_Date = P_Accounting_Date
125: --AND Accounting_Event_ID IS NULL Bug 10184420
126: AND EXISTS (SELECT 'Prepay History'
127: FROM AP_Prepay_History_All APH,
128: AP_Invoice_Distributions_All AID2
129: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
130: AND AID2.Invoice_Distribution_ID = AID1.Prepay_Distribution_ID
131: AND AID2.Invoice_ID = APH.Prepay_Invoice_ID