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 490: FROM pa_events e,

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

Line 518: FROM pa_events e,

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

Line 622: l_trans_rev_amt pa_events.bill_trans_rev_amount%TYPE;

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

Line 623: l_projfunc_rev_amount_sum pa_events.projfunc_revenue_amount%TYPE;

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

Line 624: l_converted_rev_amount pa_events.projfunc_revenue_amount%TYPE;

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

Line 625: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

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

Line 626: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

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

Line 627: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

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

Line 628: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

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

Line 629: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

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

Line 630: l_event_date pa_events.completion_date%TYPE;

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

Line 631: l_conv_date pa_events.completion_date%TYPE;

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

Line 639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

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

Line 640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

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

Line 641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

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

Line 642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

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

Line 644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

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

Line 645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

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

Line 646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

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

Line 667: FROM pa_events e,

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

Line 693: pa_events e,

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

Line 718: FROM pa_events e,

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

Line 813: l_trans_bill_amt pa_events.bill_trans_bill_amount%TYPE;

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

Line 814: l_projfunc_bill_amount_sum pa_events.projfunc_bill_amount%TYPE;

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

Line 815: l_converted_bill_amount pa_events.projfunc_bill_amount%TYPE;

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

Line 816: l_txn_currency_code pa_events.bill_trans_currency_code%TYPE;

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

Line 817: l_projfunc_currency_code pa_events.projfunc_currency_code%TYPE;

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

Line 818: l_projfunc_rate_type pa_events.projfunc_rate_type%TYPE;

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

Line 819: l_projfunc_rate_date pa_events.projfunc_rate_date%TYPE;

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

Line 820: l_projfunc_exchange_rate pa_events.projfunc_exchange_rate%TYPE;

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

Line 821: l_event_date pa_events.completion_date%TYPE;

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

Line 822: l_conv_date pa_events.completion_date%TYPE;

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

Line 830: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

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

Line 831: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

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

Line 832: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

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

Line 833: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

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

Line 835: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

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

Line 836: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

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

Line 837: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

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

Line 858: FROM pa_events e,

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

Line 886: from pa_events e,

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

Line 975: from pa_events e,

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

Line 1020: from pa_events e,

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