DBA Data[Home] [Help]

APPS.AMS_ACCESS_DENORM_PVT dependencies on JTF_RS_GROUPS_B

Line 1144: jtf_rs_groups_b jrg

1140: , act.act_access_to_object_id act_access_to_object_id
1141: , act.arc_act_access_to_object arc_act_access_to_object
1142: , admin_flag
1143: FROM ams_act_access act,
1144: jtf_rs_groups_b jrg
1145: WHERE act.arc_user_or_role_type = 'GROUP'
1146: AND act.user_or_role_id= jrg.group_id
1147: AND act.delete_flag = 'N'
1148: AND jrg.end_date_active IS NOT NULL

Line 1920: JTF_RS_GROUPS_B jrg

1916: , act.arc_act_access_to_object
1917: , jrg.group_id
1918: , admin_flag
1919: FROM ams_act_access act,
1920: JTF_RS_GROUPS_B jrg
1921: WHERE act.arc_user_or_role_type = 'GROUP'
1922: AND act.user_or_role_id= jrg.group_id
1923: AND jrg.last_update_date >= p_last_run_date
1924: AND jrg.end_date_active <= trunc(sysdate)

Line 2088: jtf_rs_groups_b jrg

2084: , act.arc_act_access_to_object
2085: , jrg.group_id
2086: , admin_flag
2087: FROM ams_act_access act,
2088: jtf_rs_groups_b jrg
2089: WHERE act.arc_user_or_role_type = 'GROUP'
2090: AND act.user_or_role_id= jrg.group_id
2091: AND act.delete_flag = 'N'
2092: -- AND jrg.last_update_date >= p_last_run_date -- this will not pick any rows which are end dated in future.