APPS.AMV_USER_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 601: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';

597: 's.user_name, ' ||
598: 'r.resource_name, ' ||
599: 'r.first_name, ' ||
600: 'r.last_name ' ||
601: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';
602: l_sql_statement2 :=
603: 'Select count(*) ' ||
604: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';
605: l_where_clause := 'Where s.resource_id = r.resource_id ';

Line 604: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';

600: 'r.last_name ' ||
601: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';
602: l_sql_statement2 :=
603: 'Select count(*) ' ||
604: 'From amv_rs_all_res_extns_vl r, jtf_rs_resource_extns s ';
605: l_where_clause := 'Where s.resource_id = r.resource_id ';
606: ELSE
607: l_sql_statement :=
608: 'Select ' ||

Line 615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';

611: 's.user_name, ' ||
612: 'r.resource_name, ' ||
613: 'r.first_name, ' ||
614: 'r.last_name ' ||
615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
616: l_sql_statement2 :=
617: 'Select count(*) ' ||
618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
619: l_where_clause :=

Line 618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';

614: 'r.last_name ' ||
615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
616: l_sql_statement2 :=
617: 'Select count(*) ' ||
618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
619: l_where_clause :=
620: 'Where m.resource_id = r.resource_id ' ||
621: 'And s.resource_id = r.resource_id ' ||
622: 'And m.delete_flag <> ''Y'' ' ||

Line 2007: , jtf_rs_resource_extns res

2003: --
2004: CURSOR Get_ResourceRole2_csr(p_res_id IN NUMBER) IS
2005: Select rel.role_relate_id
2006: From jtf_rs_role_relations_vl rel
2007: , jtf_rs_resource_extns res
2008: Where rel.role_id = p_role_id
2009: And rel.role_resource_id = p_res_id
2010: And rel.role_resource_type = G_RESOURCE_ROLE_CODE
2011: And res.resource_id = rel.role_resource_id

Line 6968: , jtf_rs_resource_extns r

6964: A.CHL_APPROVER_FLAG,
6965: A.CHL_REQUIRED_FLAG,
6966: A.CHL_REQUIRED_NEED_NOTIF_FLAG
6967: From amv_u_access a
6968: , jtf_rs_resource_extns r
6969: Where a.user_or_group_id = p_user_or_group_id
6970: And a.user_or_group_type = G_USER_ARC_TYPE
6971: And a.access_to_table_record_id = p_business_object_id
6972: And a.access_to_table_code = p_business_object_type