75:
76: -- hr_utility.trace('after insert_row');
77: select count(*)
78: into l_count
79: from pa_project_parties
80: where project_role_id = p_role_id;
81:
82: IF l_count > 0 THEN
83:
280: );
281:
282: select count(*)
283: into l_count
284: from pa_project_parties
285: where project_role_id = p_role_id;
286:
287: IF l_count > 0 THEN
288:
401: where role_status_menu_id = p_role_status_menu_id;
402:
403: select count(*)
404: into l_count
405: from pa_project_parties
406: where project_role_id = l_role_id;
407:
408:
409: select nvl(status_level, 'SYSTEM')