APPS.JTF_RS_GRP_SUM_PUB dependencies on JTF_RS_GROUPS_VL

Line 44: -- pre-reqs : depends on jtf_rs_groups_vl

40: -- ***************************************************
41: -- api name : Get Group Summary
42: -- type : public.
43: -- function : Get the Groups summary information
44: -- pre-reqs : depends on jtf_rs_groups_vl
45: -- parameters :
46: -- end of comments
47:
48: procedure Get_Group

Line 76: jtf_rs_groups_vl grp

72: grp.group_number group_number,
73: grp.start_date_active start_date_active,
74: grp.end_date_active end_date_active
75: from jtf_rs_group_members mem,
76: jtf_rs_groups_vl grp
77: where mem.resource_id in
78: (select rsc.resource_id
79: from jtf_rs_resource_extns rsc
80: where rsc.user_id = l_uid)

Line 95: from jtf_rs_groups_vl

91: group_desc,
92: group_number ,
93: start_date_active,
94: end_date_active
95: from jtf_rs_groups_vl
96: where upper(group_name) like l_group
97: union
98: select group_id,
99: group_name,

Line 105: from jtf_rs_groups_vl

101: group_desc,
102: group_number,
103: start_date_active,
104: end_date_active
105: from jtf_rs_groups_vl
106: where group_number like l_group
107: /* union
108: select group_id,
109: group_name,

Line 115: from jtf_rs_groups_vl

111: group_desc,
112: group_number,
113: start_date_active,
114: end_date_active
115: from jtf_rs_groups_vl
116: where group_id = l_grp_id
117: */ order by u_group_name, group_id ;
118:
119: cursor get_parent_group(l_par_group_id number) is

Line 124: jtf_rs_groups_vl grp

120: select grl.related_group_id,
121: grp.group_name,
122: upper(grp.group_name) u_group_name
123: from jtf_rs_grp_relations grl,
124: jtf_rs_groups_vl grp
125: where grl.group_id = l_par_group_id
126: and trunc(sysdate) between grl.start_date_active and nvl(grl.end_date_active,sysdate)
127: and nvl(grl.delete_flag,'N') = 'N'
128: and grl.related_group_id = grp.group_id

Line 138: jtf_rs_groups_vl grp

134: select grl.group_id,
135: grp.group_name,
136: upper(grp.group_name) u_group_name
137: from jtf_rs_grp_relations grl,
138: jtf_rs_groups_vl grp
139: where grl.related_group_id = l_child_group_id
140: and trunc(sysdate) between grl.start_date_active and nvl(grl.end_date_active,sysdate)
141: and nvl(grl.delete_flag,'N') = 'N'
142: and grl.group_id = grp.group_id

Line 185: -- l_qry := l_qry||' from jtf_rs_groups_vl where upper(group_name) like :b_group_name ' ;

181: END IF;
182: IF (p_called_from = 'AS') THEN
183: l_qry := ' ';
184: l_qry := ' select grp.group_id, grp.group_name, upper(grp.group_name) u_group_name, grp.group_desc, grp.group_number, grp.start_date_active, grp.end_date_active ';
185: -- l_qry := l_qry||' from jtf_rs_groups_vl where upper(group_name) like :b_group_name ' ;
186: -- i := l_bind_counter ;
187: -- bind_table(i).bind_value := l_group_name;
188:
189: IF (p_group_usage IS NULL) THEN

Line 190: l_qry := l_qry||' from jtf_rs_groups_vl grp ';

186: -- i := l_bind_counter ;
187: -- bind_table(i).bind_value := l_group_name;
188:
189: IF (p_group_usage IS NULL) THEN
190: l_qry := l_qry||' from jtf_rs_groups_vl grp ';
191: ELSE
192: l_qry := l_qry||' from jtf_rs_group_usages gu, jtf_rs_groups_vl grp ';
193: END IF;
194:

Line 192: l_qry := l_qry||' from jtf_rs_group_usages gu, jtf_rs_groups_vl grp ';

188:
189: IF (p_group_usage IS NULL) THEN
190: l_qry := l_qry||' from jtf_rs_groups_vl grp ';
191: ELSE
192: l_qry := l_qry||' from jtf_rs_group_usages gu, jtf_rs_groups_vl grp ';
193: END IF;
194:
195: l_qry := l_qry||' where upper(grp.group_name) like :b_group_name ' ;
196: i := l_bind_counter ;