APPS.PA_RETN_BILLING_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 93: FROM pa_draft_invoices_all

89: SELECT 'Y'
90: INTO ExistsFlag
91: FROM DUAL
92: WHERE EXISTS(SELECT NULL
93: FROM pa_draft_invoices_all
94: WHERE project_id = p_project_id
95: AND agreement_id = p_agreement_id
96: AND request_id = p_request_id
97: AND NVL(retention_invoice_flag,'N') = 'Y');

Line 442: FROM pa_draft_invoices_all p

438:
439:
440: SELECT NVL( MAX(p.draft_invoice_num) + 1, 1)
441: INTO TmpInvoiceNum
442: FROM pa_draft_invoices_all p
443: WHERE p.project_id = p_project_id;
444:
445: IF g1_debug_mode = 'Y' THEN
446: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'New Invoice Num : ' || TmpInvoiceNum);

Line 700: UPDATE pa_draft_invoices_all

696: IF NVL(l_inv_amount,0) <> 0 AND NVL(l_pfc_amount,0) <> 0 THEN
697: l_projfunc_invtrans_rate := NVL(l_inv_amount,0)/NVL(l_pfc_amount,0);
698: END IF;
699:
700: UPDATE pa_draft_invoices_all
701: set inv_rate_date = NULL,
702: inv_exchange_rate = NULL,
703: projfunc_invtrans_rate_type = 'User',
704: projfunc_invtrans_rate_date = sysdate,

Line 2011: FROM pa_draft_invoices_all di

2007: CURSOR cur_select_projects IS
2008: SELECT pr.project_id project_id
2009: FROM pa_projects pr, pa_project_types t
2010: WHERE NOT EXISTS (SELECT null
2011: FROM pa_draft_invoices_all di
2012: WHERE di.request_id = p_request_id
2013: AND di.project_id = pr.project_id
2014: AND NVL(di.retention_invoice_flag,'N') = 'Y')
2015: AND EXISTS( SELECT NULL