APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 67: FROM AP_Invoice_Distributions_All AID

63: AID.Accounting_Event_ID,
64: AID.Prepay_Distribution_ID,
65: AID.Prepay_Tax_Diff_Amount,
66: AID.Parent_Reversal_ID
67: FROM AP_Invoice_Distributions_All AID
68: WHERE Invoice_ID = P_Invoice_ID
69: AND Invoice_Line_Number = P_Invoice_Line_Number
70: AND Line_Type_Lookup_Code = 'PREPAY'
71: AND Accounting_Date = P_Accounting_Date

Line 75: AP_Invoice_Distributions_All AID1

71: AND Accounting_Date = P_Accounting_Date
72: AND Accounting_Event_ID IS NULL
73: AND EXISTS (SELECT 'Prepay History'
74: FROM AP_Prepay_History_All APH,
75: AP_Invoice_Distributions_All AID1
76: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
77: AND AID1.Invoice_Distribution_ID = AID.Prepay_Distribution_ID
78: AND AID1.Invoice_ID = APH.Prepay_Invoice_ID
79: AND AID1.Invoice_Line_Number = APH.Prepay_Line_Num

Line 93: FROM AP_Invoice_Distributions_All AID

89: AID.Accounting_Event_ID,
90: AID.Prepay_Distribution_ID,
91: AID.Prepay_Tax_Diff_Amount,
92: AID.Parent_Reversal_ID
93: FROM AP_Invoice_Distributions_All AID
94: WHERE Invoice_ID = P_Invoice_ID
95: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
96: AND Accounting_Event_ID IS NULL
97: AND Charge_Applicable_To_Dist_ID IN

Line 99: FROM AP_Invoice_Distributions_All AID1

95: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
96: AND Accounting_Event_ID IS NULL
97: AND Charge_Applicable_To_Dist_ID IN
98: (SELECT AID1.Invoice_Distribution_ID
99: FROM AP_Invoice_Distributions_All AID1
100: WHERE Invoice_ID = P_Invoice_ID
101: AND Invoice_Line_Number = P_Invoice_Line_Number
102: AND Line_Type_Lookup_Code = 'PREPAY'
103: AND Accounting_Date = P_Accounting_Date

Line 107: AP_Invoice_Distributions_All AID2

103: AND Accounting_Date = P_Accounting_Date
104: AND Accounting_Event_ID IS NULL
105: AND EXISTS (SELECT 'Prepay History'
106: FROM AP_Prepay_History_All APH,
107: AP_Invoice_Distributions_All AID2
108: WHERE APH.Prepay_History_ID = P_Prepay_History_ID
109: AND AID2.Invoice_Distribution_ID = AID1.Prepay_Distribution_ID
110: AND AID2.Invoice_ID = APH.Prepay_Invoice_ID
111: AND AID2.Invoice_Line_Number = APH.Prepay_Line_Num

Line 137: FROM AP_Invoice_Distributions_All AID

133: AID.Amount_Variance,
134: AID.Base_Amount_Variance,
135: AID.Historical_Flag,
136: AID.Accounting_Event_Id
137: FROM AP_Invoice_Distributions_All AID
138: WHERE AID.Invoice_ID = P_Invoice_ID
139: AND NVL(AID.Accounting_Event_ID, -99) =
140: DECODE(P_Event_ID, NULL, NVL(AID.Accounting_Event_ID, -99),
141: P_Event_ID)