APPS.PA_FUNDING_CORE dependencies on PA_EVENTS

Line 385: from pa_events

381: BEGIN
382: IF p_task_id is not null THEN
383: select 1
384: into proj_ev_exists
385: from pa_events
386: where project_id = p_project_id
387: and task_Id IS NULL
388: and rownum = 1;
389:

Line 408: --Called subprograms: pa_events_pkg.Is_Event_Billed

404: -- (1) Any expenditure item is revenue distributed ?
405: -- (2) Any event is revenue distributed?
406: -- (3) Any event is billed ??
407: --
408: --Called subprograms: pa_events_pkg.Is_Event_Billed
409: --
410: --
411: --
412: --History:

Line 466: SELECT project_id FROM PA_EVENTS

462: SELECT 'N'
463: INTO v_valid_level_change
464: FROM DUAL
465: WHERE EXISTS (
466: SELECT project_id FROM PA_EVENTS
467: WHERE project_id = p_project_id AND
468: revenue_distributed_flag ='Y');
469:
470: EXCEPTION

Line 485: FROM pa_events

481:
482: BEGIN
483:
484: FOR evt_rec IN( SELECT project_id, task_id, event_num, bill_amount
485: FROM pa_events
486: WHERE project_id = p_project_id AND
487: revenue_distributed_flag ='N' AND
488: bill_amount <> 0 ) LOOP
489:

Line 490: v_billed_flag := pa_events_pkg.Is_Event_Billed(

486: WHERE project_id = p_project_id AND
487: revenue_distributed_flag ='N' AND
488: bill_amount <> 0 ) LOOP
489:
490: v_billed_flag := pa_events_pkg.Is_Event_Billed(
491: evt_rec.project_id,
492: evt_rec.task_id,
493: evt_rec.event_num,
494: evt_rec.bill_amount);