APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_EVENTS

Line 395: FROM pa_events eve

391:
392: -- Checking event currency is same as project currency
393: SELECT COUNT(*)
394: INTO l_pc_count
395: FROM pa_events eve
396: WHERE eve.project_id = p_project_id
397: AND eve.bill_trans_currency_code <> eve.project_currency_code;
398:
399: IF (l_pc_count < 1 ) THEN

Line 410: FROM pa_events eve

406: SELECT
407: SUM(NVL(eve.bill_trans_bill_amount,0)) total_pc_unbilled_with_partial
408: INTO
409: l_pc_unbill_eve_amt_with_part
410: FROM pa_events eve
411: WHERE eve.project_id = p_project_id
412: AND nvl(eve.billed_flag,'N') = 'N'
413: AND 1 > ( SELECT COUNT(*)
414: FROM pa_events eve2

Line 414: FROM pa_events eve2

410: FROM pa_events eve
411: WHERE eve.project_id = p_project_id
412: AND nvl(eve.billed_flag,'N') = 'N'
413: AND 1 > ( SELECT COUNT(*)
414: FROM pa_events eve2
415: WHERE eve2.project_id = p_project_id
416: AND eve2.bill_trans_currency_code <> eve2.project_currency_code);
417:
418: ELSE

Line 426: FROM pa_events eve

422:
423: -- Checking event currency is same as project currency
424: SELECT COUNT(*)
425: INTO l_pfc_count
426: FROM pa_events eve
427: WHERE eve.project_id = p_project_id
428: AND eve.bill_trans_currency_code <> eve.projfunc_currency_code;
429:
430: IF (l_pfc_count < 1 ) THEN

Line 439: FROM pa_events eve

435: SELECT
436: SUM(NVL(eve.bill_trans_bill_amount,0)) tot_pfc_unbilled_with_partial
437: INTO
438: l_pfc_unbill_eve_amt_with_part
439: FROM pa_events eve
440: WHERE eve.project_id = p_project_id
441: AND nvl(eve.billed_flag,'N') = 'N'
442: AND 1 > ( SELECT COUNT(*)
443: FROM pa_events eve2

Line 443: FROM pa_events eve2

439: FROM pa_events eve
440: WHERE eve.project_id = p_project_id
441: AND nvl(eve.billed_flag,'N') = 'N'
442: AND 1 > ( SELECT COUNT(*)
443: FROM pa_events eve2
444: WHERE eve2.project_id = p_project_id
445: AND eve2.bill_trans_currency_code <> eve2.projfunc_currency_code);
446:
447: ELSE

Line 466: FROM pa_events eve

462: l_pfc_total_part_bill_amt
463: FROM pa_draft_invoice_items dii
464: WHERE dii.project_id = p_project_id
465: AND EXISTS ( SELECT null
466: FROM pa_events eve
467: WHERE eve.event_num = dii.event_num
468: AND eve.billed_flag = 'N');
469: */
470: SELECT

Line 476: FROM pa_draft_invoice_items dii, pa_events eve

472: SUM(NVL(dii.projfunc_bill_amount,0)) pfc_total_partial_billed
473: INTO
474: l_pc_total_part_bill_amt,
475: l_pfc_total_part_bill_amt
476: FROM pa_draft_invoice_items dii, pa_events eve
477: WHERE eve.project_id = p_project_id
478: and eve.project_id = dii.project_id
479: and nvl(eve.task_id, 0) = nvl(dii.task_id,0)
480: and eve.event_num = nvl(dii.event_num,0)