DBA Data[Home] [Help]

APPS.JTF_RS_GRP_SUM_PUB dependencies on JTF_RS_GRP_RELATIONS

Line 123: from jtf_rs_grp_relations grl,

119: cursor get_parent_group(l_par_group_id number) is
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'

Line 137: from jtf_rs_grp_relations grl,

133: cursor get_child_group(l_child_group_id number) is
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'