APPS.IEX_UWQ_STRAT_ENUMS_PVT dependencies on IEX_ASSIGNMENTS

Line 245: ' FROM iex_assignments iea ' ||

241:
242: --Bug4775893. Fix by LKKUMAR on 07-Dec-2005. Start.
243: l_full_brk := ' OR :RESOURCE_ID ' ||
244: ' IN (select iea.alt_resource_id '||
245: ' FROM iex_assignments iea ' ||
246: ' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
247: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
248: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
249: ' AND iea.resource_id = ' || l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;

Line 253: ' iex_assignments iea ' ||

249: ' AND iea.resource_id = ' || l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;
250:
251: l_restrict_assign_resource := ' select iea.alt_resource_id '||
252: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
253: ' iex_assignments iea ' ||
254: ' WHERE hp.collector_id = ac.collector_id ' ||
255: ' AND ac.resource_id = iea.alt_resource_id ' ||
256: ' AND iea.alt_employee_id = :PERSON_ID ' ||
257: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||

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

313: -- End for bug#7693986
314: --Start bug 6908307 gnramasa 13th June 08
315:
316: IF (l_Access = 'T') THEN --commented for bug#7499019 by PNAVEENK on 18-Nov-2008
317: SELECT count(*) into l_check from iex_assignments where
318: alt_resource_id = p_RESOURCE_ID
319: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
320: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
321: AND NVL(DELETED_FLAG,'N') = 'N';

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

328: /* l_security_where := l_sel_enum_rec.work_q_view_for_primary_node || '.resource_id in ( '
329: || l_restrict_res_grp || ' UNION ALL ' || l_restrict_assign_resource || ' ) ' ;
330: */
331: l_restrict_assign_resource := l_restrict_assign_resource ||
332: ' union all (SELECT iea.resource_id FROM iex_assignments iea where '||
333: ' iea.alt_employee_id = :PERSON_ID '||
334: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
335: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
336: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' ))';

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

417: */
418: /* if l_check>0 then
419:
420: l_restrict_assign_resource := l_restrict_assign_resource ||
421: ' union all (SELECT iea.resource_id FROM iex_assignments iea where '||
422: ' iea.alt_employee_id = :PERSON_ID '||
423: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
424: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
425: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' ))';