APPS.PA_BUDGET_MATRIX_LINES_V_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 190: -- clean up pa_resource_assignments if necessary

186:
187: END IF;
188: */
189:
190: -- clean up pa_resource_assignments if necessary
191: delete pa_resource_assignments
192: where resource_assignment_id = x_resource_assignment_id
193: and not exists
194: (select 1

Line 191: delete pa_resource_assignments

187: END IF;
188: */
189:
190: -- clean up pa_resource_assignments if necessary
191: delete pa_resource_assignments
192: where resource_assignment_id = x_resource_assignment_id
193: and not exists
194: (select 1
195: from pa_budget_lines

Line 322: -- clean up pa_resource_assignments if necessary

318:
319: END IF;
320: */
321:
322: -- clean up pa_resource_assignments if necessary
323: delete pa_resource_assignments
324: where resource_assignment_id = x_resource_assignment_id
325: and not exists
326: (select 1

Line 323: delete pa_resource_assignments

319: END IF;
320: */
321:
322: -- clean up pa_resource_assignments if necessary
323: delete pa_resource_assignments
324: where resource_assignment_id = x_resource_assignment_id
325: and not exists
326: (select 1
327: from pa_budget_lines

Line 401: FROM pa_resource_assignments a,

397: a.task_id,
398: a.resource_list_member_id,
399: a.unit_of_measure,
400: a.track_as_labor_flag
401: FROM pa_resource_assignments a,
402: pa_budget_lines l
403: WHERE l.rowid = X_Rowid
404: AND l.resource_assignment_id = a.resource_assignment_id
405: FOR UPDATE NOWAIT;