DBA Data[Home] [Help]

APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1128: (select 1 from jtf_rs_group_members

1124: and a.workitem_obj_code = b.object_code
1125: and b.ws_id = tl.ws_id
1126: and tl.language = FND_GLOBAL.CURRENT_LANGUAGE
1127: AND not exists
1128: (select 1 from jtf_rs_group_members
1129: where group_id = a.owner_id_curr
1130: and resource_id = a.assignee_id_curr
1131: and nvl(delete_flag, 'N') = 'N')
1132: and a.creation_date BETWEEN p_from_date AND p_to_date

Line 1172: (select 1 from jtf_rs_group_members

1168: AND a.owner_id_curr = rs1.group_id(+)
1169: AND a.assignee_id_curr = rs2.resource_id(+)
1170: and rs1.language=FND_GLOBAL.CURRENT_LANGUAGE
1171: AND not exists
1172: (select 1 from jtf_rs_group_members
1173: where group_id = a.owner_id_curr
1174: and resource_id = a.assignee_id_curr
1175: and nvl(delete_flag, 'N') = 'N')
1176: and a.creation_date BETWEEN p_from_date AND p_to_date