APPS.PA_MCB_INVOICE_PKG dependencies on PA_AGREEMENTS_ALL

Line 143: FROM pa_agreements_all

139: nvl(expiration_date, sysdate)
140: INTO l_funding_currency_code,
141: l_agreement_start_date,
142: l_agreement_exp_date
143: FROM pa_agreements_all
144: WHERE agreement_id =p_agreement_id;
145:
146:
147: END IF;

Line 2598: pa_agreements_all agr

2594: i.bill_through_date
2595: INTO l_customer_id,
2596: l_bill_thru_date
2597: FROM pa_draft_invoices_all i,
2598: pa_agreements_all agr
2599: WHERE i.project_id = p_project_id
2600: AND i.request_id = p_request_id
2601: AND i.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2602: AND NVL(i.generation_error_flag,'N')= 'N'