DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_EVENT_TYPES

Line 489: pa_event_types et

485: (DECODE(et.event_type_classification,'INVOICE REDUCTION', -1 * nvl(bill_trans_bill_amount,0),
486: NVL(bill_trans_bill_amount,0))) trans_bill_amount,e.bill_trans_currency_code,e.projfunc_currency_code,
487: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
488: FROM pa_events e,
489: pa_event_types et
490: WHERE e.event_type = et.event_type
491: AND e.project_id = X2_project_id
492: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
493: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)

Line 517: pa_event_types et

513: nvl(bill_amount,0)))
514: INTO X2_revenue_amount,
515: X2_invoice_amount
516: FROM pa_events e,
517: pa_event_types et
518: WHERE e.event_type = et.event_type
519: AND e.project_id = X2_project_id
520: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
521: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)