APPS.GMS_SWEEPER dependencies on GMS_EVENT_INTERSECT

Line 334: Update gms_event_intersect

330: and event_type = 'REVENUE';
331:
332: l_stage := 'intialize_revenue_records: Update raw records';
333:
334: Update gms_event_intersect
335: set revenue_accumulated='N'
336: where expenditure_item_id in
337: (Select expenditure_item_id
338: from gms_award_distributions

Line 622: from gms_event_intersect

618: and ga.revenue_distribution_rule='COST'
619: and ga.award_template_flag='DEFERRED'
620: and ga.org_id = imp.org_id
621: and (exists (select award_project_id
622: from gms_event_intersect
623: where award_project_id = ga.award_project_id
624: and event_type = 'REVENUE')
625: OR exists
626: (select award_project_id

Line 738: from gms_event_intersect gei,

734: 'GEI' from_table,
735: item.expenditure_type,
736: to_number(NULL) org_id,
737: gei.rowid
738: from gms_event_intersect gei,
739: pa_expenditure_items_all item,
740: gms_award_distributions gad ,
741: pa_resource_list_members prm
742: where gei.expenditure_item_id = gad.expenditure_item_id

Line 839: from gms_event_intersect gei,

835: item.expenditure_type,
836: to_number(NULL) exp_org_id,
837: gei.rowid
838: --item.org_id -- Bug 4732065 commented for the bug 5481465
839: from gms_event_intersect gei,
840: pa_expenditure_items_all item,
841: gms_award_distributions gad,
842: pa_resource_list_members prm
843: where gei.expenditure_item_id = gad.expenditure_item_id

Line 1413: update gms_event_intersect

1409:
1410: --2. Update the resource_accumulated = 'Y'
1411: /*if rev_gen.from_table = 'GEI' then commented and added below condition for bug 5481465*/
1412: if l_fr_tab_tbl(i) = 'GEI' then
1413: update gms_event_intersect
1414: set revenue_accumulated = 'Y'
1415: where rowid = l_rowid_tbl(i);--rev_gen.rowid; for bug 5481465
1416: /*elsif rev_gen.from_table = 'GBC' then commented and added below condition for bug 5481465*/
1417: elsif l_fr_tab_tbl(i) = 'GBC' then