APPS.GMS_BILLING_ADJUSTMENTS dependencies on PA_DRAFT_INVOICES

Line 239: pa_draft_invoices pdi

235: Cursor c_invoice_lines is
236: select pdii.event_num event_num,
237: -1*pdii.amount amount
238: from pa_draft_invoice_items pdii,
239: pa_draft_invoices pdi
240: where pdi.project_id = X_Award_Project_Id
241: and pdi.request_id = g_request_id
242: and pdii.project_id = pdi.project_id
243: and pdii.draft_invoice_num = pdi.draft_invoice_num

Line 1133: PA_DRAFT_INVOICES

1129: X_Write_Off_Flag,
1130: X_Concession_Invoice_Flag,
1131: X_Draft_Invoice_Num_Credited
1132: from
1133: PA_DRAFT_INVOICES
1134: where project_id = X_Award_Project_Id
1135: and draft_invoice_num = X_Draft_Invoice_Num;
1136: X_Err_Code := 0;
1137: EXCEPTION

Line 2113: FROM pa_draft_invoices di |

2109: /*---------------------------------------------------------------------+
2110: CURSOR GET_REV_REL_DEL_INVOICES IS |
2111: SELECT |
2112: di.draft_invoice_num |
2113: FROM pa_draft_invoices di |
2114: WHERE di.project_id = :project_id |
2115: AND di.agreement_id+0 = :agreement_id |
2116: AND di.released_date||'' is null |
2117: AND (EXISTS |

Line 2149: pa_draft_invoices I,

2145: FOR UPDATE NOWAIT;
2146:
2147: /*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2148: --The code below is used only in 10.7 as the view above is not available
2149: pa_draft_invoices I,
2150: pa_projects P
2151: where I.project_id = X_Award_Project_Id
2152: AND P.project_id = I.project_id
2153: AND I.Released_By_Person_Id IS NULL

Line 2203: pa_draft_invoices

2199: draft_invoice_num
2200: into
2201: X_Locked_Row
2202: from
2203: pa_draft_invoices
2204: where
2205: draft_invoice_num = X_Draft_Invoice_Num
2206: and project_id = X_Award_Project_Id
2207: FOR UPDATE NOWAIT;

Line 2302: pa_draft_invoices

2298: draft_invoice_num
2299: into
2300: X_Locked_Row
2301: from
2302: pa_draft_invoices
2303: where
2304: draft_invoice_num = X_Draft_Invoice_Num
2305: and project_id = X_Award_Project_Id
2306: FOR UPDATE NOWAIT;

Line 2558: ,PA_DRAFT_INVOICES b

2554: into
2555: X_Draft_Invoice_Num_Credited
2556: from
2557: PA_BILLING_INV_PROCESSED_V a
2558: ,PA_DRAFT_INVOICES b
2559: where a.project_id = X_project_id
2560: and b.project_id = a.project_id
2561: and b.draft_invoice_num = a.draft_invoice_num;
2562:

Line 2640: from pa_draft_invoices_all

2636: Begin
2637:
2638: select draft_invoice_num_credited
2639: into X_Draft_Invoice_Num_Credited
2640: from pa_draft_invoices_all
2641: where project_id = X_project_id
2642: and request_id = X_request_id
2643: and (nvl(write_off_flag,'N') = 'Y' OR
2644: nvl(concession_flag,'N') = 'Y');