APPS.GMS_OIE_INT_PKG dependencies on GMS_AWARDS_ALL

Line 148: from gms_awards_all

144: into l_award_valid
145: from dual
146: where exists (
147: select '1'
148: from gms_awards_all
149: where award_number = p_award_number
150: and award_template_flag = 'DEFERRED'
151: and status in ('ACTIVE', 'AT_RISK'));
152: RETURN TRUE;

Line 384: from gms_awards_all aw, gms_award_distributions adl

380: forall i in cur_project_id.FIRST..cur_project_id.LAST
381:
382: update ap_expense_report_lines_all aerl
383: set (award_id, award_number) = (select aw.award_id, aw.award_number
384: from gms_awards_all aw, gms_award_distributions adl
385: where aw.award_id = adl.award_id
386: and adl.expenditure_item_id = aerl.reference_1
387: and adl.document_type = 'EXP'
388: and adl.adl_status = 'A'