APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_DRAFT_INVOICE_DETAILS_ALL

Line 132: from pa_draft_invoice_details_all di

128: and ( p_active_flag <> 'A'
129: or ei.expenditure_item_date < p_txn_to_date )
130: /*
131: and not exists ( select null
132: from pa_draft_invoice_details_all di
133: where di.cc_project_id = p_project_id
134: and di.expenditure_item_id = ei.expenditure_item_id
135: )
136: */

Line 154: /* Bug#2423804 Joined the project_id of pa_draft_invoices_all and pa_draft_invoice_details_all

150: Interfaced to Accounts Receivables and Tied back to Projects. Also such interfaced invoices
151: are transferred successfully to Payables.
152: */
153:
154: /* Bug#2423804 Joined the project_id of pa_draft_invoices_all and pa_draft_invoice_details_all
155: instead of cc_project_id as the cc_project_id in pa_draft_invoices_all is populated as 0.
156: Also, the comparision of di.cc_project_id = p_project_id is changed as
157: did.cc_project_id = p_project_id.
158: These change is done in the cursors IsIcInv_Transferred_to_AR and IsIcInv_Accepted_in_AP */

Line 176: pa_draft_invoice_details_all did

172: and ( p_active_flag <> 'A'
173: or ei.expenditure_item_date < p_txn_to_date )
174: and exists ( select null
175: from pa_draft_invoices_all di,
176: pa_draft_invoice_details_all did
177: where did.cc_project_id = p_project_id
178: and did.project_id = di.project_id
179: and di.draft_invoice_num = did.draft_invoice_num
180: and did.expenditure_item_id = ei.expenditure_item_id

Line 201: pa_draft_invoice_details_all did

197: and ( p_active_flag <> 'A'
198: or ei.expenditure_item_date < p_txn_to_date )
199: and exists ( select null
200: from pa_draft_invoices_all di,
201: pa_draft_invoice_details_all did
202: where did.cc_project_id = p_project_id
203: and did.project_id = di.project_id
204: and did.expenditure_item_id = ei.expenditure_item_id
205: and di.draft_invoice_num = did.draft_invoice_num