APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_EVENTS

Line 452: FROM pa_events eve

448:
449: -- Checking event currency is same as project currency
450: SELECT COUNT(*)
451: INTO l_pc_count
452: FROM pa_events eve
453: WHERE eve.project_id = p_project_id
454: AND eve.bill_trans_currency_code <> eve.project_currency_code;
455:
456: IF (l_pc_count < 1 ) THEN

Line 467: FROM pa_events eve

463: SELECT
464: SUM(NVL(eve.bill_trans_bill_amount,0)) total_pc_unbilled_with_partial
465: INTO
466: l_pc_unbill_eve_amt_with_part
467: FROM pa_events eve
468: WHERE eve.project_id = p_project_id
469: AND nvl(eve.billed_flag,'N') = 'N'
470: AND 1 > ( SELECT COUNT(*)
471: FROM pa_events eve2

Line 471: FROM pa_events eve2

467: FROM pa_events eve
468: WHERE eve.project_id = p_project_id
469: AND nvl(eve.billed_flag,'N') = 'N'
470: AND 1 > ( SELECT COUNT(*)
471: FROM pa_events eve2
472: WHERE eve2.project_id = p_project_id
473: AND eve2.bill_trans_currency_code <> eve2.project_currency_code);
474:
475: ELSE

Line 483: FROM pa_events eve

479:
480: -- Checking event currency is same as project currency
481: SELECT COUNT(*)
482: INTO l_pfc_count
483: FROM pa_events eve
484: WHERE eve.project_id = p_project_id
485: AND eve.bill_trans_currency_code <> eve.projfunc_currency_code;
486:
487: IF (l_pfc_count < 1 ) THEN

Line 496: FROM pa_events eve

492: SELECT
493: SUM(NVL(eve.bill_trans_bill_amount,0)) tot_pfc_unbilled_with_partial
494: INTO
495: l_pfc_unbill_eve_amt_with_part
496: FROM pa_events eve
497: WHERE eve.project_id = p_project_id
498: AND nvl(eve.billed_flag,'N') = 'N'
499: AND 1 > ( SELECT COUNT(*)
500: FROM pa_events eve2

Line 500: FROM pa_events eve2

496: FROM pa_events eve
497: WHERE eve.project_id = p_project_id
498: AND nvl(eve.billed_flag,'N') = 'N'
499: AND 1 > ( SELECT COUNT(*)
500: FROM pa_events eve2
501: WHERE eve2.project_id = p_project_id
502: AND eve2.bill_trans_currency_code <> eve2.projfunc_currency_code);
503:
504: ELSE

Line 523: FROM pa_events eve

519: l_pfc_total_part_bill_amt
520: FROM pa_draft_invoice_items dii
521: WHERE dii.project_id = p_project_id
522: AND EXISTS ( SELECT null
523: FROM pa_events eve
524: WHERE eve.event_num = dii.event_num
525: AND eve.billed_flag = 'N');
526: */
527: /* Bug:14470226 dii.task_id replaced with dii.event_task_id*/

Line 534: FROM pa_draft_invoice_items dii, pa_events eve

530: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
531: INTO
532: l_pc_total_part_bill_amt,
533: l_pfc_total_part_bill_amt
534: FROM pa_draft_invoice_items dii, pa_events eve
535: WHERE eve.project_id = p_project_id
536: and eve.project_id = dii.project_id
537: and nvl(eve.task_id, 0) = nvl(dii.event_task_id,0)
538: and eve.event_num = nvl(dii.event_num,0)