APPS.PA_RETN_BILLING_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 692: FROM pa_draft_invoice_items dii

688: SELECT NVL(sum(dii.inv_amount),0),
689: NVL(sum(dii.projfunc_bill_amount),0)
690: INTO l_inv_amount,
691: l_pfc_amount
692: FROM pa_draft_invoice_items dii
693: WHERE dii.project_id = p_project_id
694: AND dii.draft_invoice_num = p_draft_invoice_num;
695:
696: IF NVL(l_inv_amount,0) <> 0 AND NVL(l_pfc_amount,0) <> 0 THEN

Line 984: INSERT INTO pa_draft_invoice_items

980: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'RetnLineText : ' || RetnLineText);
981: pa_retention_util.write_log('Create_Retn_Invoice_Lines: ' || 'Insert DII');
982: END IF;
983:
984: INSERT INTO pa_draft_invoice_items
985: ( PROJECT_ID,
986: DRAFT_INVOICE_NUM,
987: LINE_NUM,
988: AMOUNT,