APPS.AP_ACCTG_PREPAY_DIST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 84: FROM AP_Invoice_Distributions_All AID

80: AID.Accounting_Event_ID,
81: AID.Prepay_Distribution_ID,
82: AID.Prepay_Tax_Diff_Amount,
83: AID.Parent_Reversal_ID
84: FROM AP_Invoice_Distributions_All AID
85: WHERE Invoice_ID = P_Invoice_ID
86: AND Invoice_Line_Number = P_Invoice_Line_Number
87: AND Line_Type_Lookup_Code = 'PREPAY'
88: AND Accounting_Date = P_Accounting_Date

Line 94: AP_Invoice_Distributions_All AID1

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
98: AND AID1.Invoice_Line_Number = APH.Prepay_Line_Num

Line 112: FROM AP_Invoice_Distributions_All AID

108: AID.Accounting_Event_ID,
109: AID.Prepay_Distribution_ID,
110: AID.Prepay_Tax_Diff_Amount,
111: AID.Parent_Reversal_ID
112: FROM AP_Invoice_Distributions_All AID
113: WHERE Invoice_ID = P_Invoice_ID
114: AND Line_Type_Lookup_Code IN ('NONREC_TAX','REC_TAX')
115: --AND Accounting_Event_ID IS NULL
116: AND nvl(AID.Posted_flag, 'N') <> 'Y'

Line 120: FROM AP_Invoice_Distributions_All AID1

116: AND nvl(AID.Posted_flag, 'N') <> 'Y'
117: AND nvl(AID.Encumbered_flag, 'N') <> 'Y'
118: AND Charge_Applicable_To_Dist_ID IN
119: (SELECT AID1.Invoice_Distribution_ID
120: FROM AP_Invoice_Distributions_All AID1
121: WHERE Invoice_ID = P_Invoice_ID
122: AND Invoice_Line_Number = P_Invoice_Line_Number
123: AND Line_Type_Lookup_Code = 'PREPAY'
124: AND Accounting_Date = P_Accounting_Date

Line 128: AP_Invoice_Distributions_All AID2

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
132: AND AID2.Invoice_Line_Number = APH.Prepay_Line_Num

Line 159: FROM AP_Invoice_Distributions_All AID

155: AID.Amount_Variance,
156: AID.Base_Amount_Variance,
157: AID.Historical_Flag,
158: AID.Accounting_Event_Id
159: FROM AP_Invoice_Distributions_All AID
160: WHERE AID.Invoice_ID = P_Invoice_ID
161: AND NVL(AID.Accounting_Event_ID, -99) =
162: DECODE(P_Event_ID, NULL, NVL(AID.Accounting_Event_ID, -99),
163: P_Event_ID)