APPS.PA_CC_AR_AP_TRANSFER dependencies on PA_DRAFT_INVOICE_ITEMS

Line 123: select count(*) lines_counter from pa_draft_invoice_items

119: and ppc.customer_id=p_project_customer_id
120: and ppc.project_id=p_project_id;
121:
122: Cursor c_invoice_lines_counter(p_project_id in number,p_draft_invoice_number in number)IS
123: select count(*) lines_counter from pa_draft_invoice_items
124: where project_id=p_project_id
125: and draft_invoice_num=p_draft_invoice_number
126: and invoice_line_type <> 'NET ZERO ADJUSTMENT'/* added as fix for Bug 1580854 */
127: and amount <> 0; /* Added for Bug 9711235 */

Line 144: FROM pa_draft_invoice_items pdii,

140: pdii.cc_tax_task_id task_id,
141: pdii.inv_amount pa_quantity,
142: arinv.line_number pa_cc_ar_invoice_line_num,
143: arinv.customer_trx_line_id cust_trx_line_id -- added for bug 5045406
144: FROM pa_draft_invoice_items pdii,
145: ra_customer_trx_lines_all arinv
146: -- ap_tax_codes_all aptax,
147: -- ar_vat_tax_all artax
148: where arinv.interface_line_attribute6= pdii.line_num

Line 170: FROM pa_draft_invoice_items pdii,

166: pdii.cc_tax_task_id task_id,
167: pdii.inv_amount pa_quantity,
168: arinv.line_number pa_cc_ar_invoice_line_num,
169: arinv.customer_trx_line_id cust_trx_line_id -- added for bug 5045406
170: FROM pa_draft_invoice_items pdii,
171: ra_customer_trx_lines_all arinv
172: where arinv.interface_line_attribute6= pdii.line_num
173: and pdii.project_id=p_project_id
174: and pdii.draft_invoice_num=p_draft_invoice_number