APPS.OZF_CLAIM_PVT dependencies on AMS_JTF_RS_EMP_V

Line 982: from jtf_rs_group_members a, ams_jtf_rs_emp_v b

978: l_access_list gp_access_list_type;
979:
980: CURSOR group_member_csr(p_id in number) is
981: select b.category, b.resource_id
982: from jtf_rs_group_members a, ams_jtf_rs_emp_v b
983: where a.resource_id = b.resource_id
984: and a.group_id = p_id
985: and a.delete_flag = 'N';
986:

Line 5238: FROM AMS_JTF_RS_EMP_V

5234: l_owner_id number;
5235:
5236: CURSOR owner_name_csr(p_id in number) is
5237: SELECT FULL_NAME
5238: FROM AMS_JTF_RS_EMP_V
5239: WHERE RESOURCE_ID = p_id;
5240: l_owner_name varchar2(2000);
5241:
5242: CURSOR lines_info_csr(p_id in number)IS