APPS.PA_PURGE_BILLING dependencies on PA_EVENTS_AR

Line 1119: PA_Events_AR ar

1115: mc.Projfunc_Inv_Rate_Date,
1116: mc.Projfunc_Inv_Exchange_Rate,
1117: mc.description
1118: from Pa_Mc_Events mc,
1119: PA_Events_AR ar
1120: where ar.Purge_Project_Id = p_project_id
1121: and mc.event_id = ar.event_id;
1122: */
1123:

Line 1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;

1190: -- in the commit size.
1191:
1192: l_commit_size := pa_utils2.arpur_mrc_commit_size / 2 ;
1193:
1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;
1195:
1196: /* Funding MRC Changes : Added the column zero_revenue_amount_flag */
1197:
1198: insert into PA_Events_AR

Line 1198: insert into PA_Events_AR

1194: pa_debug.debug( ' ->Before insert into PA_Events_AR') ;
1195:
1196: /* Funding MRC Changes : Added the column zero_revenue_amount_flag */
1197:
1198: insert into PA_Events_AR
1199: (
1200: PURGE_BATCH_ID,
1201: PURGE_RELEASE,
1202: PURGE_PROJECT_ID,

Line 1442: pa_debug.debug( ' ->After insert into PA_Events_AR') ;

1438: ) ;
1439:
1440: l_NoOfRecordsIns := SQL%ROWCOUNT;
1441:
1442: pa_debug.debug( ' ->After insert into PA_Events_AR') ;
1443:
1444:
1445: /*Code Changes for Bug No.2984871 start */
1446: if l_NoOfRecordsIns > 0 then

Line 1473: pa_events_ar ev2

1469: where (ev.rowid)
1470: in
1471: ( select ev1.rowid
1472: from pa_events ev1,
1473: pa_events_ar ev2
1474: where nvl(ev2.task_id,-99) = nvl(ev1.task_id,-99)
1475: and ev2.event_num = ev1.event_num
1476: and ev2.project_id = ev1.project_id
1477: and ev2.purge_project_id = p_project_id

Line 1483: from pa_events_ar ev2

1479: */
1480: delete from pa_events ev
1481: where (ev.project_id, ev.event_num) in
1482: ( select ev2.project_id, ev2.event_num
1483: from pa_events_ar ev2
1484: where nvl(ev2.task_id,-99) = nvl(ev.task_id,-99)
1485: and ev2.purge_project_id = p_project_id
1486: )
1487: and ev.project_id = p_project_id; -- Perf Bug 2695202