APPS.IEX_UWQ_STRAT_ENUMS_PVT dependencies on IEX_ASSIGNMENTS

Line 202: ' FROM iex_assignments iea ' ||

198:
199: --Bug4775893. Fix by LKKUMAR on 07-Dec-2005. Start.
200: l_full_brk := ' OR :RESOURCE_ID ' ||
201: ' IN (select iea.alt_resource_id '||
202: ' FROM iex_assignments iea ' ||
203: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
204: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
205: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
206: ' AND iea.resource_id = ' || l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;

Line 210: ' iex_assignments iea ' ||

206: ' AND iea.resource_id = ' || l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;
207:
208: l_restrict_assign_resource := ' select iea.alt_resource_id '||
209: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
210: ' iex_assignments iea ' ||
211: ' WHERE hp.collector_id = ac.collector_id ' ||
212: ' AND ac.resource_id = iea.alt_resource_id ' ||
213: ' AND iea.alt_employee_id = :PERSON_ID ' ||
214: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||

Line 258: SELECT count(*) into l_check from iex_assignments where

254:
255: --Start bug 6908307 gnramasa 13th June 08
256:
257: -- IF (l_Access = 'T') THEN commented for bug#7499019 by PNAVEENK on 18-Nov-2008
258: SELECT count(*) into l_check from iex_assignments where
259: alt_resource_id = p_RESOURCE_ID
260: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
261: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
262: AND NVL(DELETED_FLAG,'N') = 'N';

Line 349: ' union all (SELECT iea.resource_id FROM iex_assignments iea where '||

345: */
346: if l_check>0 then
347:
348: l_restrict_assign_resource := l_restrict_assign_resource ||
349: ' union all (SELECT iea.resource_id FROM iex_assignments iea where '||
350: ' iea.alt_employee_id = :PERSON_ID '||
351: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
352: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
353: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' ))';