APPS.PA_BILLING_AMOUNT dependencies on PA_EVENT_TYPES

Line 416: pa_event_types et

412: NVL(e.bill_trans_bill_amount,0))) trans_bill_amount,
413: e.bill_trans_currency_code,e.projfunc_currency_code,e.projfunc_rate_type,
414: e.projfunc_rate_date,e.projfunc_exchange_rate
415: FROM pa_events e,
416: pa_event_types et
417: WHERE e.event_type = et.event_type
418: AND e.project_id = X2_project_id
419: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
420: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)

Line 442: pa_event_types et

438: nvl(bill_amount,0)))
439: INTO X2_revenue_amount,
440: X2_invoice_amount
441: FROM pa_events e,
442: pa_event_types et
443: WHERE e.event_type = et.event_type
444: AND e.project_id = X2_project_id
445: AND nvl(e.task_id,0) = nvl(X2_task_id, nvl(e.task_id,0))
446: AND e.completion_date <= nvl(X2_accrue_through_date, sysdate)

Line 836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

832: SELECT DECODE(e.revenue_distributed_flag,'N', NVL(e.bill_trans_rev_amount,0),0) trans_rev_amount,
833: DECODE(pdii.event_num,NULL, NVL(e.bill_trans_bill_amount,0),0) trans_bill_amount,
834: e.bill_trans_currency_code,
835: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
836: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
837: WHERE e.project_id = X2_project_id
838: AND pdii.project_id (+)= e.project_id
839: AND pdii.event_num (+)= e.event_num
840: AND nvl(pdii.event_task_id,0) = nvl(e.task_id,0)

Line 863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii

859: sum(decode(pdii.event_num,
860: NULL, nvl(e.bill_amount,0),
861: 0))
862: INTO current_event_revenue, current_event_invoice
863: FROM pa_events e, pa_event_types et, pa_draft_invoice_items pdii
864: WHERE e.project_id = X2_project_id
865: AND pdii.project_id (+)= e.project_id
866: and pdii.event_num (+)= e.event_num
867: and nvl(pdii.event_task_id,0) = nvl(e.task_id,0)

Line 1107: pa_event_types et

1103: AND substr(distribution_rule,1,instr(distribution_rule,'/')-1)
1104: IN ('COST','EVENT')
1105: AND exists ( select 'x'
1106: from pa_events e,
1107: pa_event_types et
1108: where e.project_id = X_project_id
1109: and e.event_type = et.event_type
1110: and et.event_type_classification = 'SCHEDULED PAYMENTS');
1111: /* Bug 2389765 . Cost Budget is needed only when the Distribution Rule is