APPS.PA_PWP_SUMM_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 22: PA_PWP_CUSTOMER_SUMM PPCS , PA_DRAFT_INVOICE_ITEMS PDII

18:
19: CURSOR Recdraft IS
20: SELECT (PDII.PROJFUNC_BILL_AMOUNT/PDII.INV_AMOUNT) F_amount ,(PDII.PROJECT_BILL_AMOUNT/PDII.INV_AMOUNT) P_amount,
21: PDII.draft_invoice_num Inv_num FROM
22: PA_PWP_CUSTOMER_SUMM PPCS , PA_DRAFT_INVOICE_ITEMS PDII
23: WHERE PPCS.draft_invoice_num = PDII.draft_invoice_num
24: AND PPCS.INV_LINE_AMOUNT = 0
25: and PDII.project_id = P_Project_Id
26: AND TRANSFER_STATUS_CODE = 'A'

Line 28: (SELECT min(PDII2.LINE_NUM) from PA_DRAFT_INVOICE_ITEMS PDII2 where

24: AND PPCS.INV_LINE_AMOUNT = 0
25: and PDII.project_id = P_Project_Id
26: AND TRANSFER_STATUS_CODE = 'A'
27: and PDII.LINE_NUM =
28: (SELECT min(PDII2.LINE_NUM) from PA_DRAFT_INVOICE_ITEMS PDII2 where
29: PDII.draft_invoice_num = PDII2.draft_invoice_num AND
30: PDII2.project_id = P_Project_Id AND PDII2.INV_AMOUNT <> 0
31: group by PDII2.project_id,PDII2.draft_invoice_num);
32:

Line 150: FROM pa_draft_invoice_items pdii

146: ,SUM(PROJECT_BILL_AMOUNT)f
147: ,SUM(INV_AMOUNT)g
148: ,SUM(INV_AMOUNT)h
149: ,SUM(INV_AMOUNT) i
150: FROM pa_draft_invoice_items pdii
151: WHERE pdii .project_id = pwp.project_id
152: AND pdii.draft_invoice_num = pwp.draft_invoice_num
153: )
154: WHERE project_id = P_Project_Id;

Line 257: FROM pa_draft_invoice_items pdii,

253: =
254: (SELECT SUM(INV_AMOUNT ) -- bug 8225160
255: ,SUM(PROJFUNC_BILL_AMOUNT)
256: ,SUM(PROJECT_BILL_AMOUNT)
257: FROM pa_draft_invoice_items pdii,
258: pa_draft_invoices_all pda
259: WHERE pwp.project_id = pda.project_id
260: AND pwp.draft_invoice_num = pda.draft_invoice_num
261: AND pda.gl_date between l_start_date AND l_end_date