APPS.AMV_USER_PVT dependencies on AMV_RS_ALL_RES_EXTNS_VL

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 834: 'From amv_rs_all_res_extns_vl r ';

830: 'r.email user_name, ' ||
831: 'r.resource_name, ' ||
832: 'r.first_name, ' ||
833: 'r.last_name ' ||
834: 'From amv_rs_all_res_extns_vl r ';
835: l_sql_statement2 :=
836: 'Select count(*) ' ||fnd_global.local_chr(10)||
837: 'From amv_rs_all_res_extns_vl r ';
838: --l_where_clause := 'Where r.start_date_active < sysdate ' ||

Line 837: 'From amv_rs_all_res_extns_vl r ';

833: 'r.last_name ' ||
834: 'From amv_rs_all_res_extns_vl r ';
835: l_sql_statement2 :=
836: 'Select count(*) ' ||fnd_global.local_chr(10)||
837: 'From amv_rs_all_res_extns_vl r ';
838: --l_where_clause := 'Where r.start_date_active < sysdate ' ||
839: -- 'And nvl(r.end_date_active, sysdate+1) > sysdate ';
840: IF ( p_resource_id = FND_API.G_MISS_NUM ) THEN
841: l_where_clause :=

Line 6567: From amv_u_access u, amv_rs_all_res_extns_vl r

6563: U.CAN_CREATE_DIST_RULE_FLAG,
6564: U.CHL_APPROVER_FLAG,
6565: U.CHL_REQUIRED_FLAG,
6566: U.CHL_REQUIRED_NEED_NOTIF_FLAG
6567: From amv_u_access u, amv_rs_all_res_extns_vl r
6568: Where u.user_or_group_id = r.resource_id
6569: And u.user_or_group_type = G_USER_ARC_TYPE
6570: And access_to_table_code = G_CHAN_ARC_TYPE
6571: And u.access_to_table_record_id = p_channel_id;