APPS.OZF_CLAIM_PVT dependencies on AMS_JTF_RS_EMP_V

Line 905: from jtf_rs_group_members a, ams_jtf_rs_emp_v b

901: l_access_list gp_access_list_type;
902:
903: CURSOR group_member_csr(p_id in number) is
904: select b.category, b.resource_id
905: from jtf_rs_group_members a, ams_jtf_rs_emp_v b
906: where a.resource_id = b.resource_id
907: and a.group_id = p_id
908: and a.delete_flag = 'N';
909:

Line 4393: FROM AMS_JTF_RS_EMP_V

4389: l_owner_id number;
4390:
4391: CURSOR owner_name_csr(p_id in number) is
4392: SELECT FULL_NAME
4393: FROM AMS_JTF_RS_EMP_V
4394: WHERE RESOURCE_ID = p_id;
4395: l_owner_name varchar2(2000);
4396:
4397: CURSOR lines_info_csr(p_id in number)IS