eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 458: from jtf_rs_grp_relations rel

454:
455: cursor get_child_cur(l_group_id number)
456: is
457: select count(*) child_cnt
458: from jtf_rs_grp_relations rel
459: connect by related_group_id = prior group_id
460: and nvl(delete_flag, 'N') <> 'Y'
461: AND ((trunc(rel.start_date_active) <= prior rel.start_date_active
462: AND nvl(rel.end_date_active, prior rel.start_date_active) >=

Line 1606: from jtf_rs_grp_relations rel

1602:
1603: cursor get_child_cur(l_group_id number)
1604: is
1605: select count(*) child_cnt
1606: from jtf_rs_grp_relations rel
1607: connect by related_group_id = prior group_id
1608: and nvl(delete_flag, 'N') <> 'Y'
1609: AND ((trunc(rel.start_date_active) <= prior rel.start_date_active
1610: AND nvl(rel.end_date_active, prior rel.start_date_active) >=

Line 2729: from jtf_rs_grp_relations rel

2725:
2726: cursor get_child_cur(l_group_id number)
2727: is
2728: select count(*) child_cnt
2729: from jtf_rs_grp_relations rel
2730: connect by related_group_id = prior group_id
2731: and nvl(delete_flag, 'N') <> 'Y'
2732: AND ((trunc(rel.start_date_active) <= prior rel.start_date_active
2733: AND nvl(rel.end_date_active, prior rel.start_date_active) >=