eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on IEX_ASSIGNMENTS

Line 239: SELECT count(*) into l_check from iex_assignments where alt_resource_id = p_RESOURCE_ID

235: -- Territory Assignment Changes
236: IF (l_Access = 'T') THEN
237:
238: begin
239: SELECT count(*) into l_check from iex_assignments where alt_resource_id = p_RESOURCE_ID
240: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
241: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
242: AND NVL(DELETED_FLAG,'N') = 'N';
243: exception

Line 253: ' iex_assignments iea ' ||

249: l_security_where :=
250: --'customer_id in (select hp.party_id '||
251: l_filter_col_str1|| -- Added for Bug #6311505 bibeura 23-Oct-2007
252: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
253: ' iex_assignments iea ' ||
254: ' WHERE hp.collector_id = ac.collector_id ' ||
255: l_filter_cond_str|| -- Added for Bug #6311505 bibeura 23-Oct-2007
256: -- ' AND hp.cust_account_id = -1 ' || Bug4775052. Fix By LKKUMAR on 29-Nov-2005
257: ' AND ac.resource_id = iea.resource_id ' ||

Line 429: ' iex_assignments iea ' ||

425: l_security_where :=
426: --'customer_id in (select hp.party_id '||
427: l_filter_col_str1|| -- Added for Bug #6311505 bibeura 23-Oct-2007
428: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
429: ' iex_assignments iea ' ||
430: ' WHERE hp.collector_id = ac.collector_id ' ||
431: l_filter_cond_str|| -- Added for Bug #6311505 bibeura 23-Oct-2007
432: -- ' AND hp.cust_account_id = -1 ' || Bug4775052. Fix By LKKUMAR on 29-Nov-2005
433: ' AND ac.resource_id = iea.resource_id ' ||

Line 740: SELECT count(*) INTO l_check FROM iex_assignments where

736: FETCH c_collector_ID INTO l_collector_id;
737: CLOSE c_collector_id;
738:
739: begin
740: SELECT count(*) INTO l_check FROM iex_assignments where
741: alt_resource_id = p_RESOURCE_ID
742: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
743: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
744: AND NVL(DELETED_FLAG,'N') = 'N';

Line 764: ' iex_assignments iea ' ||

760: /* If (l_check > 0 ) then
761: l_security_where :=
762: 'party_id in (select hp.party_id ' ||
763: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
764: ' iex_assignments iea ' ||
765: ' WHERE hp.collector_id = ac.collector_id ' ||
766: ' AND ac.resource_id = iea.resource_id ' ||
767: ' AND hp.cust_account_id = -1 ' ||
768: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 820: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

816: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
817: end if;
818:
819: if l_check>0 then
820: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
821: ' iea.alt_employee_id = :PERSON_ID '||
822: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
823: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
824: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 954: ' iex_assignments iea ' ||

950: /* If (l_check > 0 ) then
951: l_security_where :=
952: 'party_id in (select hp.party_id '||
953: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
954: ' iex_assignments iea ' ||
955: ' WHERE hp.collector_id = ac.collector_id ' ||
956: ' AND ac.resource_id = iea.resource_id ' ||
957: ' AND hp.cust_account_id = -1 ' ||
958: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 1010: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

1006: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1007: end if;
1008:
1009: if l_check>0 then
1010: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1011: ' iea.alt_employee_id = :PERSON_ID '||
1012: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1013: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1014: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 1302: SELECT count(*) INTO l_check FROM iex_assignments

1298: FETCH c_collector_id INTO l_collector_id;
1299: CLOSE c_collector_id;
1300:
1301: begin
1302: SELECT count(*) INTO l_check FROM iex_assignments
1303: where alt_resource_id = P_RESOURCE_ID
1304: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1305: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1306: --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.

Line 1328: ' iex_assignments iea ' ||

1324: If (l_check > 0) then
1325: l_security_where :=
1326: 'party_id in (select hp.party_id '||
1327: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1328: ' iex_assignments iea ' ||
1329: ' WHERE hp.collector_id = ac.collector_id ' ||
1330: ' AND hp.cust_account_id = -1 ' ||
1331: ' AND ac.resource_id = iea.resource_id ' ||
1332: ' AND iea.alt_employee_id = :PERSON_ID '||

Line 1379: ' iex_assignments iea ' ||

1375: If (l_check > 0) then
1376: l_security_where :=
1377: 'party_id in (select hp.party_id '||
1378: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1379: ' iex_assignments iea ' ||
1380: ' WHERE hp.collector_id = ac.collector_id ' ||
1381: ' AND ' || l_view_name ||
1382: '.cust_account_id = hp.cust_account_id ' ||
1383: ' AND ac.resource_id = iea.resource_id ' ||

Line 1447: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

1443: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1444: end if;
1445:
1446: if l_check>0 then
1447: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1448: ' iea.alt_employee_id = :PERSON_ID '||
1449: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1450: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1451: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 1565: ' iex_assignments iea ' ||

1561: If (l_check > 0) then
1562: l_security_where :=
1563: 'party_id in (select hp.party_id '||
1564: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1565: ' iex_assignments iea ' ||
1566: ' WHERE hp.collector_id = ac.collector_id ' ||
1567: ' AND hp.cust_account_id = -1 ' ||
1568: ' AND ac.resource_id = iea.resource_id ' ||
1569: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 1617: ' iex_assignments iea ' ||

1613: If (l_check > 0) then
1614: l_security_where :=
1615: 'party_id in (select hp.party_id '||
1616: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
1617: ' iex_assignments iea ' ||
1618: ' WHERE hp.collector_id = ac.collector_id ' ||
1619: ' AND ' || l_view_name ||
1620: '.cust_account_id = hp.cust_account_id ' ||
1621: ' AND ac.resource_id = iea.resource_id ' ||

Line 1685: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

1681: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
1682: end if;
1683:
1684: if l_check>0 then
1685: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
1686: ' iea.alt_employee_id = :PERSON_ID '||
1687: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
1688: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
1689: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 1983: SELECT count(*) INTO l_check FROM iex_assignments

1979: FETCH c_collector_id INTO l_collector_id;
1980: CLOSE c_collector_id;
1981:
1982: begin
1983: SELECT count(*) INTO l_check FROM iex_assignments
1984: where alt_resource_id = p_RESOURCE_ID
1985: AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
1986: AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
1987: --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.

Line 2010: ' iex_assignments iea ' ||

2006: If (l_check > 0) then
2007: l_security_where :=
2008: 'party_id in (select hp.party_id '||
2009: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2010: ' iex_assignments iea ' ||
2011: ' WHERE hp.collector_id = ac.collector_id ' ||
2012: ' AND hp.cust_account_id = -1 ' ||
2013: ' AND ac.resource_id = iea.resource_id ' ||
2014: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 2060: ' iex_assignments iea ' ||

2056: If (l_check > 0) then
2057: l_security_where :=
2058: 'party_id in (select hp.party_id '||
2059: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2060: ' iex_assignments iea ' ||
2061: ' WHERE hp.collector_id = ac.collector_id ' ||
2062: ' AND ' || l_view_name ||
2063: '.cust_account_id = hp.cust_account_id ' ||
2064: ' AND ac.resource_id = iea.resource_id ' ||

Line 2120: ' iex_assignments iea ' ||

2116: If (l_check > 0) then
2117: l_security_where :=
2118: 'party_id in (select hp.party_id '||
2119: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2120: ' iex_assignments iea ' ||
2121: ' WHERE hp.collector_id = ac.collector_id ' ||
2122: ' AND ' || l_view_name ||
2123: '.site_use_id = hp.site_use_id ' ||
2124: ' AND ac.resource_id = iea.resource_id ' ||

Line 2180: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

2176: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
2177: end if;
2178:
2179: if l_check>0 then
2180: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
2181: ' iea.alt_employee_id = :PERSON_ID '||
2182: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
2183: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
2184: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||

Line 2303: ' iex_assignments iea ' ||

2299: If (l_check > 0) then
2300: l_security_where :=
2301: 'party_id in (select hp.party_id '||
2302: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2303: ' iex_assignments iea ' ||
2304: ' WHERE hp.collector_id = ac.collector_id ' ||
2305: ' AND hp.cust_account_id = -1 ' ||
2306: ' AND ac.resource_id = iea.resource_id ' ||
2307: ' AND iea.alt_employee_id = :PERSON_ID ' ||

Line 2353: ' iex_assignments iea ' ||

2349: If (l_check > 0) then
2350: l_security_where :=
2351: 'party_id in (select hp.party_id '||
2352: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2353: ' iex_assignments iea ' ||
2354: ' WHERE hp.collector_id = ac.collector_id ' ||
2355: ' AND ' || l_view_name ||
2356: '.cust_account_id = hp.cust_account_id ' ||
2357: ' AND ac.resource_id = iea.resource_id ' ||

Line 2409: ' iex_assignments iea ' ||

2405: If (l_check > 0) then
2406: l_security_where :=
2407: 'party_id in (select hp.party_id '||
2408: ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
2409: ' iex_assignments iea ' ||
2410: ' WHERE hp.collector_id = ac.collector_id ' ||
2411: ' AND ' || l_view_name ||
2412: '.site_use_id = hp.site_use_id ' ||
2413: ' AND ac.resource_id = iea.resource_id ' ||

Line 2472: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||

2468: l_security_where := ' :person_id = :person_id and collector_resource_id = :COLLECTOR_RESOURCE_ID ';
2469: end if;
2470:
2471: if l_check>0 then
2472: l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
2473: ' iea.alt_employee_id = :PERSON_ID '||
2474: ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
2475: ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
2476: ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||