APPS.PA_PWP_SUMM_PKG dependencies on PA_DRAFT_INVOICES

Line 81: FROM PA_DRAFT_INVOICES_ALL I

77: , l_user_id
78: , l_date
79: , l_user_id
80: , l_date
81: FROM PA_DRAFT_INVOICES_ALL I
82: , PA_DRAFT_INVOICES_ALL ORG_INV
83: , PA_CUSTOMERS_V C
84: ,PA_LOOKUPS LK
85: ,PA_AGREEMENTS_ALL A

Line 82: , PA_DRAFT_INVOICES_ALL ORG_INV

78: , l_date
79: , l_user_id
80: , l_date
81: FROM PA_DRAFT_INVOICES_ALL I
82: , PA_DRAFT_INVOICES_ALL ORG_INV
83: , PA_CUSTOMERS_V C
84: ,PA_LOOKUPS LK
85: ,PA_AGREEMENTS_ALL A
86: WHERE I.AGREEMENT_ID = A.AGREEMENT_ID

Line 209: pa_draft_invoices_all pda

205: (SELECT SUM(INV_AMOUNT ) -- bug 8225160
206: ,SUM(PROJFUNC_BILL_AMOUNT)
207: ,SUM(PROJECT_BILL_AMOUNT)
208: FROM pa_draft_invoice_items pdii,
209: pa_draft_invoices_all pda
210: WHERE pwp.project_id = pda.project_id
211: AND pwp.draft_invoice_num = pda.draft_invoice_num
212: AND pda.gl_date between l_start_date AND l_end_date
213: AND pdii.project_id = pwp.project_id

Line 226: PA_DRAFT_INVOICES PDA

222: UPDATE PA_PWP_CUSTOMER_SUMM pwp
223: SET INV_CP_BILL_AMOUNT = (SELECT SUM(ARP.amount_due_original )
224:
225: FROM AR_PAYMENT_SCHEDULES ARP,
226: PA_DRAFT_INVOICES PDA
227: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
228: AND ARP.CUSTOMER_TRX_ID = PDA.SYSTEM_REFERENCE
229: AND PDA.GL_DATE BETWEEN l_start_date AND l_end_date
230: )

Line 316: FROM pa_draft_invoices

312: L_INVOICE_NUM VARCHAR2(30);
313: BEGIN
314: SELECT ra_invoice_number
315: INTO l_invoice_num
316: FROM pa_draft_invoices
317: WHERE project_id = p_project_id
318: AND draft_invoice_num = p_draft_invoice_num;
319: RETURN l_invoice_num;
320: EXCEPTION

Line 340: FROM pa_draft_invoices

336: L_INVOICE_DATE DATE;
337: BEGIN
338: SELECT invoice_date
339: INTO L_INVOICE_DATE
340: FROM pa_draft_invoices
341: WHERE project_id = p_project_id
342: AND draft_invoice_num = p_draft_invoice_num;
343: RETURN L_INVOICE_DATE;
344: EXCEPTION