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:

Line 143: FROM pa_draft_invoice_items pdii,

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

Line 168: FROM pa_draft_invoice_items pdii,

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