APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_ROLES

Line 1408: l_person_id wf_roles.orig_system_id%type;

1404: p_loggedin_person_id in number
1405: )RETURN varchar2
1406: IS
1407: l_result varchar2(2) := 'N';
1408: l_person_id wf_roles.orig_system_id%type;
1409: BEGIN
1410:
1411: select orig_system_id into l_person_id from WF_NOTIFICATIONS ,wf_roles
1412: WHERE

Line 1411: select orig_system_id into l_person_id from WF_NOTIFICATIONS ,wf_roles

1407: l_result varchar2(2) := 'N';
1408: l_person_id wf_roles.orig_system_id%type;
1409: BEGIN
1410:
1411: select orig_system_id into l_person_id from WF_NOTIFICATIONS ,wf_roles
1412: WHERE
1413: notification_id=p_notification_id and
1414: recipient_role = name and
1415: orig_system = 'PER';