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 2583: pa_agreements_all agr

2579: i.bill_through_date
2580: INTO l_customer_id,
2581: l_bill_thru_date
2582: FROM pa_draft_invoices_all i,
2583: pa_agreements_all agr
2584: WHERE i.project_id = p_project_id
2585: AND i.request_id = p_request_id
2586: AND i.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2587: AND NVL(i.generation_error_flag,'N')= 'N'