eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILL_PCT dependencies on PA_EVENTS

Line 53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

49: /* Declaring varible for MCB2 */
50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

50: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

51: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

52: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
53: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

54: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

55: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

56: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
57: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
58: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
59: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
60: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
61: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
62: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
63: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
64: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

430: X2_revenue_amount OUT NOCOPY REAL,
431: X2_invoice_amount OUT NOCOPY REAL)
432: IS
433: /* Declaring varible for MCB2 */
434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

Line 435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

431: X2_invoice_amount OUT NOCOPY REAL)
432: IS
433: /* Declaring varible for MCB2 */
434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

Line 436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;

432: IS
433: /* Declaring varible for MCB2 */
434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;

433: /* Declaring varible for MCB2 */
434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;

434: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

435: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

436: l_passd_amt pa_events.bill_trans_bill_amount%TYPE := 0;
437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;

Line 441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

437: l_projfunc_amount_sum pa_events.projfunc_revenue_amount%TYPE;
438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;
445: l_conv_date pa_events.completion_date%TYPE;

Line 442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

438: l_converted_amount pa_events.projfunc_revenue_amount%TYPE;
439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;
445: l_conv_date pa_events.completion_date%TYPE;
446: l_denominator Number;

Line 443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

439: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;
445: l_conv_date pa_events.completion_date%TYPE;
446: l_denominator Number;
447: l_numerator Number;

Line 444: l_event_date pa_events.completion_date%TYPE;

440: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;
445: l_conv_date pa_events.completion_date%TYPE;
446: l_denominator Number;
447: l_numerator Number;
448: l_staus Varchar2(30);

Line 445: l_conv_date pa_events.completion_date%TYPE;

441: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
442: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
443: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
444: l_event_date pa_events.completion_date%TYPE;
445: l_conv_date pa_events.completion_date%TYPE;
446: l_denominator Number;
447: l_numerator Number;
448: l_staus Varchar2(30);
449: l_calling_process Varchar2(50);

Line 454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

450: l_project_id pa_projects_all.project_id%TYPE;
451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

451: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

452: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

453: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
454: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

455: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

456: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

457: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
458: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
459: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
460: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
461: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
462: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
463: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
464: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
465: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 488: FROM pa_events e,

484: NVL(bill_trans_rev_amount,0))) trans_rev_amount,
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))

Line 516: FROM pa_events e,

512: 'INVOICE REDUCTION', -1 * nvl(bill_amount,0),
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))

Line 620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

616: pending_pctrev REAL;
617: accrued_pctrev REAL;
618:
619: /* Varible for MCB2 */
620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;

617: accrued_pctrev REAL;
618:
619: /* Varible for MCB2 */
620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;

618:
619: /* Varible for MCB2 */
620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

619: /* Varible for MCB2 */
620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

620: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;
621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;

Line 625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

621: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;
622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;
629: l_conv_date pa_events.completion_date%TYPE;

Line 626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

622: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;
623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;
629: l_conv_date pa_events.completion_date%TYPE;
630: l_denominator Number;

Line 627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

623: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;
629: l_conv_date pa_events.completion_date%TYPE;
630: l_denominator Number;
631: l_numerator Number;

Line 628: l_event_date pa_events.completion_date%TYPE;

624: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;
629: l_conv_date pa_events.completion_date%TYPE;
630: l_denominator Number;
631: l_numerator Number;
632: l_staus Varchar2(30);

Line 629: l_conv_date pa_events.completion_date%TYPE;

625: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
626: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
627: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
628: l_event_date pa_events.completion_date%TYPE;
629: l_conv_date pa_events.completion_date%TYPE;
630: l_denominator Number;
631: l_numerator Number;
632: l_staus Varchar2(30);
633: l_project_id pa_projects_all.project_id%TYPE;

Line 637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

633: l_project_id pa_projects_all.project_id%TYPE;
634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

634: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

635: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

636: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
637: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

638: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

639: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

640: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
641: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
642: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
643: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
644: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
645: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
646: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
647: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
648: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 665: FROM pa_events e,

661:
662: CURSOR pctfunc_revenue(X2_project_id Number,X2_task_id Number) IS
663: SELECT NVL(e.bill_trans_rev_amount,0) trans_rev_amount,e.bill_trans_currency_code,
664: e.projfunc_currency_code,e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
665: FROM pa_events e,
666: pa_billing_assignments bea,
667: pa_billing_extensions be
668: where be.billing_extension_id = bea.billing_extension_id
669: and e.project_id = X2_project_id

Line 691: pa_events e,

687: WHERE dri.project_id = X2_project_id
688: AND nvl(dri.task_id,0) = decode(X2_task_id, NULL, nvl(dri.task_id,0), X2_task_id )
689: AND (EXISTS ( select '1'
690: from pa_cust_event_rev_dist_lines erdl,
691: pa_events e,
692: pa_billing_assignments bea,
693: pa_billing_extensions be
694: where be.billing_extension_id = bea.billing_extension_id
695: and bea.billing_assignment_id = e.billing_assignment_id

Line 716: FROM pa_events e,

712: */
713: /*
714: SELECT sum(nvl(e.revenue_amount,0))
715: INTO pending_pctrev
716: FROM pa_events e,
717: pa_billing_assignments bea,
718: pa_billing_extensions be
719: where be.billing_extension_id = bea.billing_extension_id
720: and e.project_id = X2_project_id

Line 811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

807: task_billed_ev_ccinv REAL;
808: billed_ccinv REAL;
809:
810: /* Varibles added for MCB2 */
811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

Line 812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;

808: billed_ccinv REAL;
809:
810: /* Varibles added for MCB2 */
811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

Line 813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;

809:
810: /* Varibles added for MCB2 */
811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

Line 814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

810: /* Varibles added for MCB2 */
811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

Line 815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

811: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;
812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;

Line 816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

812: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;
813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;
820: l_conv_date pa_events.completion_date%TYPE;

Line 817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

813: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;
814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;
820: l_conv_date pa_events.completion_date%TYPE;
821: l_denominator Number;

Line 818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

814: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;
815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;
820: l_conv_date pa_events.completion_date%TYPE;
821: l_denominator Number;
822: l_numerator Number;

Line 819: l_event_date pa_events.completion_date%TYPE;

815: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;
816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;
820: l_conv_date pa_events.completion_date%TYPE;
821: l_denominator Number;
822: l_numerator Number;
823: l_staus Varchar2(30);

Line 820: l_conv_date pa_events.completion_date%TYPE;

816: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;
817: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;
818: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;
819: l_event_date pa_events.completion_date%TYPE;
820: l_conv_date pa_events.completion_date%TYPE;
821: l_denominator Number;
822: l_numerator Number;
823: l_staus Varchar2(30);
824: l_project_id pa_projects_all.project_id%TYPE;

Line 828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

824: l_project_id pa_projects_all.project_id%TYPE;
825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

825: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

826: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

827: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
828: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

829: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

830: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

831: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
832: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
833: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
834: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
835: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
836: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
837: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
838: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
839: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 856: FROM pa_events e,

852:
853: CURSOR pctfunc_invoice(X2_project_id Number,X2_task_id Number) IS
854: SELECT NVL(e.bill_trans_bill_amount,0) trans_bill_amount,e.bill_trans_currency_code,e.projfunc_currency_code,
855: e.projfunc_rate_type,e.projfunc_rate_date,e.projfunc_exchange_rate
856: FROM pa_events e,
857: pa_billing_assignments bea,
858: pa_billing_extensions be
859: WHERE be.billing_extension_id = bea.billing_extension_id
860: AND bea.billing_assignment_id = e.billing_assignment_id

Line 884: from pa_events e,

880: */
881: /*
882: SELECT sum(nvl(e.bill_amount,0))
883: INTO pending_ccinv
884: from pa_events e,
885: pa_billing_assignments bea,
886: pa_billing_extensions be
887: where be.billing_extension_id = bea.billing_extension_id
888: and bea.billing_assignment_id = e.billing_assignment_id

Line 973: from pa_events e,

969: INTO billed_ccinv
970: FROM pa_draft_invoice_items dii
971: WHERE dii.project_id = X2_project_id
972: AND (EXISTS (select '1'
973: from pa_events e,
974: pa_billing_assignments bea,
975: pa_billing_extensions be
976: where be.billing_extension_id = bea.billing_extension_id
977: and bea.billing_assignment_id = e.billing_assignment_id

Line 1018: from pa_events e,

1014: FROM pa_draft_invoice_items pdii
1015: WHERE pdii.event_task_id = X2_task_id
1016: AND pdii.Project_ID = X2_Project_ID -- Perf Bug 2695332
1017: AND EXISTS (select '1'
1018: from pa_events e,
1019: pa_billing_assignments bea,
1020: pa_billing_extensions be
1021: where be.billing_extension_id = bea.billing_extension_id
1022: and bea.billing_assignment_id = e.billing_assignment_id