DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1589: jtf_rs_role_relations jrrr

1585: AND jrgu.group_id = jrgm.group_id
1586: AND jrgu.usage = 'SALES'
1587: AND nvl(jrgm.delete_flag, 'N') <> 'Y'
1588: AND exists (SELECT 1 FROM
1589: jtf_rs_role_relations jrrr
1590: WHERE jrrr.role_resource_id= jrgm.group_member_id
1591: AND trunc( nvl(jrrr.start_date_active, SYSDATE)) <= trunc( SYSDATE )
1592: AND trunc( nvl(jrrr.end_date_active, SYSDATE)) >= trunc( SYSDATE )
1593: AND jrrr.role_resource_type='RS_GROUP_MEMBER'