APPS.GMS_SWEEPER dependencies on GMS_BILLING_CANCELLATIONS

Line 317: l_stage := 'intialize_revenue_records: Delete gms_billing_cancellations';

313: into l_award_project_id
314: from gms_awards_all -- Bug 4732065
315: where award_id = p_award_id;
316:
317: l_stage := 'intialize_revenue_records: Delete gms_billing_cancellations';
318:
319: delete
320: from gms_billing_cancellations
321: where award_project_id = l_award_project_id

Line 320: from gms_billing_cancellations

316:
317: l_stage := 'intialize_revenue_records: Delete gms_billing_cancellations';
318:
319: delete
320: from gms_billing_cancellations
321: where award_project_id = l_award_project_id
322: and actual_project_id = p_project_id;
323:
324: l_stage := 'intialize_revenue_records: Update Burden Records';

Line 627: from gms_billing_cancellations

623: where award_project_id = ga.award_project_id
624: and event_type = 'REVENUE')
625: OR exists
626: (select award_project_id
627: from gms_billing_cancellations
628: where award_project_id = ga.award_project_id
629: and calling_process='Revenue')) ;
630:
631: --Bug 4732065 : To fetch sob when called from baseline

Line 802: -- from gms_billing_cancellations gbi,

798: -- gbi.bill_amount amount,
799: -- 'GBI' from_table,
800: -- nvl(gbi.burden_exp_type,item.expenditure_type),
801: -- nvl(pea.incurred_by_organization_id,item.override_to_organization_id) org_id, gbi.rowid
802: -- from gms_billing_cancellations gbi,
803: -- pa_expenditure_items_all item ,
804: -- pa_expenditures_all pea,
805: -- gms_award_distributions gad ,
806: -- pa_resource_list_members prm

Line 906: from gms_billing_cancellations gbi,

902: nvl(gbi.burden_exp_type,item.expenditure_type),
903: nvl(pea.incurred_by_organization_id,item.override_to_organization_id) exp_org_id,
904: gbi.rowid
905: --item.org_id -- Bug 4732065 commented for the bug 5481465
906: from gms_billing_cancellations gbi,
907: pa_expenditure_items_all item,
908: pa_expenditures_all pea,
909: gms_award_distributions gad,
910: pa_resource_list_members prm

Line 1412: delete from gms_billing_cancellations

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
1412: delete from gms_billing_cancellations
1413: where rowid = l_rowid_tbl(i);--rev_gen.rowid; for bug 5481465
1414: end if;
1415: x_old_award_id := l_award_id_tbl(i) ;
1416: x_old_project_id := l_project_id_tbl(i);