DBA Data[Home] [Help]

APPS.GMS_PA_API dependencies on PA_PROJECT_TYPES

Line 157: and exists (select 1 from pa_project_types t, pa_projects pa

153: -- Start, Bug 1756179
154: update pa_expenditure_items_all
155: set billable_flag = x_billable_flag
156: where expenditure_item_id = new_rec.expenditure_item_id
157: and exists (select 1 from pa_project_types t, pa_projects pa
158: where pa.project_id = SOURCE_PROJECT_ID
159: and pa.project_type=t.project_type
160: and t.Project_type_class_code= 'INDIRECT');
161: -- End, Bug 1756179