DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_OVERRIDE_FIELDS_V

Line 141: FROM pa_override_fields_v pof

137: -- Added the nvl condition in the cursor query for bug 4954698
138: CURSOR l_override_fields_csr --(c_project_id NUMBER) Bug 5478390: c_project_id no longer used
139: IS
140: SELECT TYPE
141: FROM pa_override_fields_v pof
142: WHERE pof.pa_field_name = 'CUSTOMER_NAME'
143: AND EXISTS(SELECT 'x' from pa_projects_all PP
144: -- replaced c_project_id with p_orig_project_id in where clause for Bug 5478390
145: WHERE PP.project_id = p_orig_project_id

Line 622: FROM pa_override_fields_v pof

618: /*Commented since not being used anymore: Bug 5478390
619: CURSOR l_override_fields_csr (c_project_id NUMBER)
620: IS
621: SELECT TYPE
622: FROM pa_override_fields_v pof
623: WHERE pof.pa_field_name = 'CUSTOMER_NAME'
624: AND EXISTS(SELECT 'x' from pa_projects_all PP
625: WHERE PP.project_id = c_project_id
626: AND PP.created_from_project_id =