DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1575: jtf_rs_role_relations jrrr

1571: AND jrgu.group_id = jrgm.group_id
1572: AND jrgu.usage = 'SALES'
1573: AND nvl(jrgm.delete_flag, 'N') <> 'Y'
1574: AND exists (SELECT 1 FROM
1575: jtf_rs_role_relations jrrr
1576: WHERE jrrr.role_resource_id= jrgm.group_member_id
1577: AND trunc( nvl(jrrr.start_date_active, SYSDATE)) <= trunc( SYSDATE )
1578: AND trunc( nvl(jrrr.end_date_active, SYSDATE)) >= trunc( SYSDATE )
1579: AND jrrr.role_resource_type='RS_GROUP_MEMBER'