DBA Data[Home] [Help]

APPS.PA_BILLING_AMOUNT dependencies on PA_AGREEMENTS_ALL

Line 974: pa_agreements_all a

970: - nvl(psf.projfunc_billed_amount,0))
971: INTO lowest_revenue_amount,
972: lowest_invoice_amount
973: FROM pa_summary_project_fundings psf,
974: pa_agreements_all a
975: WHERE a.agreement_id = psf.agreement_id
976: AND psf.project_id = X2_project_id
977: AND psf.task_id = X2_task_id
978: AND DECODE (X2_calling_process,'Revenue',

Line 991: pa_agreements_all a, /* Changed table from pa_agreements to pa_agreements_all for MCB2 */

987: * (100/nvl(pc.customer_bill_split,100)) ) /* Bug 5718115*/
988: INTO lowest_revenue_amount,
989: lowest_invoice_amount
990: FROM pa_summary_project_fundings psf,
991: pa_agreements_all a, /* Changed table from pa_agreements to pa_agreements_all for MCB2 */
992: pa_projects p,
993: pa_project_customers pc
994: WHERE
995: a.agreement_id = psf.agreement_id