APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on WF_LOCAL_USER_ROLES

Line 584: l_role_name wf_local_user_roles.role_name%TYPE;

580: and orig_system_id = c_team_id;
581:
582: l_grp_role_name wf_local_roles.name%TYPE;
583: l_team_role_name wf_local_roles.name%TYPE;
584: l_role_name wf_local_user_roles.role_name%TYPE;
585: l_role_orig_system_id wf_local_user_roles.role_orig_system_id%TYPE;
586:
587: l_mem_role_start_date date;
588: l_mem_role_end_date date;

Line 585: l_role_orig_system_id wf_local_user_roles.role_orig_system_id%TYPE;

581:
582: l_grp_role_name wf_local_roles.name%TYPE;
583: l_team_role_name wf_local_roles.name%TYPE;
584: l_role_name wf_local_user_roles.role_name%TYPE;
585: l_role_orig_system_id wf_local_user_roles.role_orig_system_id%TYPE;
586:
587: l_mem_role_start_date date;
588: l_mem_role_end_date date;
589: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));

Line 1063: FROM wf_local_user_roles

1059: l_res_usr_role_name wf_local_roles.name%TYPE := l_res_usr_orig_system||':'||to_char(p_resource_id);
1060:
1061: CURSOR res_user_role_cur IS
1062: SELECT role_name, role_orig_system, role_orig_system_id
1063: FROM wf_local_user_roles
1064: WHERE user_name = l_res_usr_role_name
1065: AND user_orig_system = l_res_usr_orig_system
1066: AND user_orig_system_id = p_resource_id
1067: AND role_name <> l_res_usr_role_name;