APPS.GMS_SWEEPER dependencies on PA_IMPLEMENTATIONS_ALL

Line 615: pa_implementations_all imp -- Bug 4732065 :

611: select distinct ga.award_id award_id, gspf.project_id project_id,imp.set_of_books_id
612: from gms_summary_project_fundings gspf,
613: gms_installments gi,
614: gms_awards_all ga, -- Bug 4732065 : To run the process across org
615: pa_implementations_all imp -- Bug 4732065 :
616: where gspf.installment_id = gi.installment_id
617: and gi.award_id = ga.award_id
618: and ga.revenue_distribution_rule='COST'
619: and ga.award_template_flag='DEFERRED'

Line 636: pa_implementations_all imp

632:
633: Cursor c_get_sob (p_award_id IN NUMBER) IS
634: select set_of_books_id
635: from gms_awards_all ga,
636: pa_implementations_all imp
637: where ga.award_id = p_award_id
638: and imp.org_id = ga.org_id;
639:
640: l_sob_id NUMBER;