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.

[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 460: from jtf_rs_grp_relations rel

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

Line 1620: from jtf_rs_grp_relations rel

1616:
1617: cursor get_child_cur(l_group_id number)
1618: is
1619: select count(*) child_cnt
1620: from jtf_rs_grp_relations rel
1621: connect by related_group_id = prior group_id
1622: and nvl(delete_flag, 'N') <> 'Y'
1623: AND ((trunc(rel.start_date_active) <= prior rel.start_date_active
1624: AND nvl(rel.end_date_active, prior rel.start_date_active) >=

Line 2755: from jtf_rs_grp_relations rel

2751:
2752: cursor get_child_cur(l_group_id number)
2753: is
2754: select count(*) child_cnt
2755: from jtf_rs_grp_relations rel
2756: connect by related_group_id = prior group_id
2757: and nvl(delete_flag, 'N') <> 'Y'
2758: AND ((trunc(rel.start_date_active) <= prior rel.start_date_active
2759: AND nvl(rel.end_date_active, prior rel.start_date_active) >=