APPS.JAI_AP_RPT_PRRG_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 69: from ap_invoice_distributions_all

65: and (p_vendor_site_id is null or vendor_site_id = p_vendor_site_id)
66: and (p_org_id is null or org_id = p_org_id)
67: and exists
68: (select '1'
69: from ap_invoice_distributions_all
70: where invoice_id = aia.invoice_id
71: and line_type_lookup_code in ('ITEM','ACCRUAL')--nprahsar for bug # 7225946*/
72: and po_distribution_id is not null
73: and nvl(reversal_flag, 'N') <> 'Y'

Line 90: from ap_invoice_distributions_all

86: /*
87: In the above cursor added invoice_line_number by Brathod, for Bug#4510143 to pass invoice_line_number
88: as parameter to jai_ap_utils_pkg.get_apportion_factor
89: */
90: from ap_invoice_distributions_all
91: where invoice_id = p_invoice_id
92: and line_type_lookup_code in ('ITEM','ACCRUAL')
93: and po_distribution_id is not null
94: and nvl(reversal_flag, 'N') <> 'Y'

Line 167: from ap_invoice_distributions_all

163: where tax_id = p_tax_id;
164:
165: cursor c_get_misc_tax_line_amt (p_invoice_id number, p_distribution_line_number number, p_invoice_distribution_id number ) is
166: select amount
167: from ap_invoice_distributions_all
168: where invoice_id = p_invoice_id
169: and distribution_line_number = p_distribution_line_number
170: and invoice_distribution_id = p_invoice_distribution_id /*Added by nprashar for Bug # 6803557*/
171: and accounting_date >= p_invoice_date_from /* Modified by Ramananda for bug:4071409 */