APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_DRAFT_INVOICES_ALL

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 155: instead of cc_project_id as the cc_project_id in pa_draft_invoices_all is populated as 0.

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 */
159:

Line 175: from pa_draft_invoices_all di,

171: and ei.cc_rejection_code is NULL
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

Line 200: from pa_draft_invoices_all di,

196: and ei.cc_rejection_code is NULL
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

Line 370: from pa_draft_invoices_all di,

366: select 'IP INV NOT TIEDBACK SUCCESSFULLY'
367: from dual
368: where exists (
369: select null
370: from pa_draft_invoices_all di,
371: pa_project_customers ppc,
372: pa_agreements_all pag
373: where di.project_id = p_project_id
374: and di.agreement_id = pag.agreement_id

Line 387: from pa_draft_invoices_all di,

383: select 'IP INV NOT ACCEPTED IN AP'
384: from dual
385: where exists (
386: select null
387: from pa_draft_invoices_all di,
388: pa_project_customers ppc,
389: pa_agreements_all pag
390: where di.project_id = p_project_id
391: and di.project_id = ppc.project_id