DBA Data[Home] [Help]

APPS.JAI_AP_RPT_PRRG_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 142: from JAI_AP_MATCH_INV_TAXES

138: p_invoice_id number,
139: p_parent_distribution_id number,
140: p_po_distribution_id number) is
141: select distribution_line_number, tax_id,invoice_distribution_id, tax_amount /*Changed by nprashar for bug # 6803557 */
142: from JAI_AP_MATCH_INV_TAXES
143: where invoice_id = p_invoice_id
144: and parent_invoice_distribution_id = p_parent_distribution_id
145: and po_distribution_id = p_po_distribution_id
146: union

Line 148: from JAI_AP_MATCH_INV_TAXES

144: and parent_invoice_distribution_id = p_parent_distribution_id
145: and po_distribution_id = p_po_distribution_id
146: union
147: select distribution_line_number, tax_id,invoice_distribution_id, tax_amount /*Changed by nprashar for bug # 6803557 */
148: from JAI_AP_MATCH_INV_TAXES
149: where invoice_id = p_invoice_id
150: and parent_invoice_distribution_id is null
151: and po_distribution_id is null
152: and (po_header_id, po_line_id, line_location_id)

Line 192: from JAI_AP_MATCH_INV_TAXES

188: where transaction_id = p_rcv_transaction_id)
189: and A.tax_id not in
190: (
191: select tax_id
192: from JAI_AP_MATCH_INV_TAXES
193: where invoice_id = p_invoice_id
194: and parent_invoice_distribution_id = p_parent_distribution_id
195: and po_distribution_id = p_po_distribution_id
196: union

Line 198: from JAI_AP_MATCH_INV_TAXES

194: and parent_invoice_distribution_id = p_parent_distribution_id
195: and po_distribution_id = p_po_distribution_id
196: union
197: select tax_id
198: from JAI_AP_MATCH_INV_TAXES
199: where invoice_id = p_invoice_id
200: and parent_invoice_distribution_id is null
201: and po_distribution_id is null
202: and (po_header_id, po_line_id, line_location_id)

Line 233: from JAI_AP_MATCH_INV_TAXES

229: where po_distribution_id = p_po_distribution_id)
230: and A.tax_id not in
231: (
232: select tax_id
233: from JAI_AP_MATCH_INV_TAXES
234: where invoice_id = p_invoice_id
235: and parent_invoice_distribution_id = p_parent_distribution_id
236: and po_distribution_id = p_po_distribution_id
237: union

Line 239: from JAI_AP_MATCH_INV_TAXES

235: and parent_invoice_distribution_id = p_parent_distribution_id
236: and po_distribution_id = p_po_distribution_id
237: union
238: select tax_id
239: from JAI_AP_MATCH_INV_TAXES
240: where invoice_id = p_invoice_id
241: and parent_invoice_distribution_id is null
242: and po_distribution_id is null
243: and (po_header_id, po_line_id, line_location_id)