APPS.JTF_RS_ACTIVE_REC_CONC_PUB dependencies on JTF_RS_GRP_RELATIONS

Line 162: FROM jtf_rs_grp_relations grp1

158: SELECT /*+ parallel(grp1) */
159: grp1.group_id child_group_id, grp1.related_group_id parent_group_id,
160: grp1.start_date_active start_date_active, grp1.end_date_active end_date_active,
161: MAX(end_date_active) OVER (partition by GROUP_ID,DELETE_FLAG) max_end_date
162: FROM jtf_rs_grp_relations grp1
163: WHERE grp1.end_date_active <= l_sysdate -- if it is null it is OK
164: AND grp1.delete_flag = 'N'
165: and grp1.group_id NOT IN (
166: -- check if they have any other parent

Line 168: FROM jtf_rs_grp_relations grp2

164: AND grp1.delete_flag = 'N'
165: and grp1.group_id NOT IN (
166: -- check if they have any other parent
167: SELECT /*+ hash_aj parallel(grp2) */ grp2.group_id
168: FROM jtf_rs_grp_relations grp2
169: WHERE NVL(grp2.end_date_active, l_sysdate) >= l_sysdate
170: AND grp2.delete_flag = 'N'
171: )
172: )

Line 212: FROM jtf_rs_grp_relations grp1

208: AND den3.latest_relationship_flag IS NULL
209: AND NOT EXISTS ( -- check if child groups have any other active parent
210: -- apart from existing active parent in hierarchy in consideration
211: SELECT /*+ use_hash(grp1) PARALLEL(grp1) */ '1'
212: FROM jtf_rs_grp_relations grp1
213: WHERE grp1.start_date_active <= l_sysdate
214: AND NVL(grp1.end_date_active, TO_DATE('12/31/4712','MM/DD/RRRR')) > x.end_date_active
215: AND grp1.delete_flag = 'N'
216: AND grp1.group_id = den3.group_id