DBA Data[Home] [Help]

APPS.IGW_PROJECT_FUNDINGS_PVT dependencies on PA_PROJECT_TYPES

Line 90: pa_project_types pt

86: INTO x_project_id
87: FROM pa_lookups lk,
88: pa_projects p,
89: gms_project_types gpt,
90: pa_project_types pt
91: WHERE p.segment1 = p_project_number
92: AND pt.project_type = p.project_type
93: AND gpt.project_type = pt.project_type
94: AND p.project_status_code not in ('CLOSED' , 'UNAPPROVED')

Line 115: pa_project_types t

111:
112: SELECT count(distinct t.cost_budget_entry_method_code)
113: INTO l_count_budget_entry_method
114: FROM pa_projects p,
115: pa_project_types t
116: WHERE ((p.project_id = x_project_id) OR
117: (p.project_id IN
118: (SELECT project_id
119: FROM igw_project_fundings