DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_EVENT_TYPES

Line 491: pa_event_types et

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

Line 519: pa_event_types et

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