APPS.PA_ROLE_STATUS_MENU_PVT dependencies on PA_PROJECT_PARTIES

Line 79: from pa_project_parties

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:

Line 284: from pa_project_parties

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:

Line 405: from pa_project_parties

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')