APPS.ZPB_EXCP_PVT dependencies on FND_RESPONSIBILITY

Line 357: l_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%type;

353: l_query_name ZPB_TASK_PARAMETERS.value%type;
354: l_query VARCHAR2(8000);
355: l_user_id NUMBER;
356: l_resp_id NUMBER;
357: l_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%type;
358: l_task_id VARCHAR2(16);
359: l_dim ZPB_STATUS_SQL.dimension_name%type;
360: l_hier ZPB_STATUS_SQL.hierarchy_name%type;
361: l_count NUMBER;

Line 405: from fnd_responsibility

401: --dbms_output.put_line(l_user_id);
402: --dbms_output.put_line(l_resp_id);
403:
404: select responsibility_key into l_resp_key
405: from fnd_responsibility
406: where responsibility_id = l_resp_id;
407:
408: l_task_id := to_char(p_task_id);
409: --dbms_output.put_line(l_task_id);