APPS.GMS_SWEEPER dependencies on GMS_BURDEN_COMPONENTS

Line 326: Update gms_burden_components

322: and actual_project_id = p_project_id;
323:
324: l_stage := 'intialize_revenue_records: Update Burden Records';
325:
326: Update gms_burden_components
327: set revenue_accumulated='N'
328: where award_project_id = l_award_project_id
329: and actual_project_id = p_project_id
330: and event_type = 'REVENUE';

Line 770: from gms_burden_components gbc,

766: 'GBC' from_table,
767: gbc.burden_exp_type,
768: nvl(pea.incurred_by_organization_id ,item.override_to_organization_id) org_id,
769: gbc.rowid
770: from gms_burden_components gbc,
771: pa_expenditure_items_all item ,
772: pa_expenditures_all pea,
773: gms_award_distributions gad ,
774: pa_resource_list_members prm

Line 872: from gms_burden_components gbc,

868: gbc.burden_exp_type,
869: nvl(pea.incurred_by_organization_id,item.override_to_organization_id) exp_org_id,
870: gbc.rowid
871: --item.org_id -- Bug 4732065 commented for the bug 5481465
872: from gms_burden_components gbc,
873: pa_expenditure_items_all item,
874: pa_expenditures_all pea,
875: gms_award_distributions gad,
876: pa_resource_list_members prm

Line 1407: update gms_burden_components

1403: set revenue_accumulated = 'Y'
1404: where rowid = l_rowid_tbl(i);--rev_gen.rowid; for bug 5481465
1405: /*elsif rev_gen.from_table = 'GBC' then commented and added below condition for bug 5481465*/
1406: elsif l_fr_tab_tbl(i) = 'GBC' then
1407: update gms_burden_components
1408: set revenue_accumulated = 'Y'
1409: where rowid = l_rowid_tbl(i);--rev_gen.rowid; for bug 5481465
1410: /*elsif rev_gen.from_table = 'GBI' then commented and added below condition for bug 5481465*/
1411: elsif l_fr_tab_tbl(i) = 'GBI' then