DBA Data[Home] [Help]

APPS.AMS_ACCESS_DENORM_PVT dependencies on JTF_RS_GROUPS_B

Line 973: JTF_RS_GROUPS_B jrg

969: , act.arc_act_access_to_object
970: , jrg.group_id
971: , admin_flag
972: FROM ams_act_access act,
973: JTF_RS_GROUPS_B jrg
974: WHERE act.arc_user_or_role_type = 'GROUP'
975: AND act.user_or_role_id= jrg.group_id
976: AND jrg.last_update_date >= p_last_run_date
977: AND jrg.end_date_active <= trunc(sysdate)

Line 1141: jtf_rs_groups_b jrg

1137: , act.arc_act_access_to_object
1138: , jrg.group_id
1139: , admin_flag
1140: FROM ams_act_access act,
1141: jtf_rs_groups_b jrg
1142: WHERE act.arc_user_or_role_type = 'GROUP'
1143: AND act.user_or_role_id= jrg.group_id
1144: AND act.delete_flag = 'N'
1145: -- AND jrg.last_update_date >= p_last_run_date -- this will not pick any rows which are end dated in future.