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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10


CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
    WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

Line: 22


     'SELECT  GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
     ' = GLSOB.SET_OF_BOOKS_ID');

Line: 24


  L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');

Line: 51


    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 56


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 60


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 67


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 123


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 136


  select preference_value
  into l_strategy_level
  from iex_app_preferences_vl
  where preference_name='COLLECTIONS STRATEGY LEVEL';

Line: 141


	l_filter_col_str1 := 'customer_id in (select hp.party_id ';

Line: 142


	l_filter_col_str2 := 'select hp.party_id ';

Line: 146


        l_filter_col_str1 := 'cust_account_id in (select hp.cust_account_id ';

Line: 147


	l_filter_col_str2 := 'select hp.cust_account_id ';

Line: 151


        l_filter_col_str1 := 'site_use_id in (select hp.site_use_id ';

Line: 152


	l_filter_col_str2 := 'select hp.site_use_id ';

Line: 155


	l_filter_col_str1 := 'customer_id in (select hp.party_id ';

Line: 156


	l_filter_col_str2 := 'select hp.party_id ';

Line: 185


  l_str_bkr2 := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = '
  || l_sel_enum_rec.work_q_view_for_primary_node || '.customer_id '
  --Bug5261831. Fix By LKKUMAR on 14-Jun-2006. Start.
  || ' AND NVL(BKR.DISPOSITION_CODE,''GRANTED'') NOT IN (''DISMISSED'',''NEGOTIATION'',''WITHDRAWN'')) ';

Line: 196


   SELECT count(*) into l_check from iex_assignments where
   alt_resource_id =  p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 232


          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  )'; -- Changed by gnramasa for bug 6363290 27-Aug-07

Line: 255


          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  )'; -- Changed by gnramasa for bug 6363290 27-Aug-07

Line: 367


          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 388


          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 474


    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 479


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 483


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 490


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 495


    SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
      and resource_type = 'RS_RESOURCE';

Line: 525


  CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
    WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

Line: 529


    SELECT PREFERENCE_VALUE
	FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 550


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 603


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id = p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 609


   select count(1) into l_group_check
   from ar_collectors where status='A' and
   nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';

Line: 618


          'party_id in  (select hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.resource_id = iea.resource_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE)  ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles  hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 648


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles  hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 669


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 676


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 686


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';

Line: 808


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.resource_id = iea.resource_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID   ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND hp.cust_account_id = -1  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 837


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND hp.cust_account_id = -1  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 859


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 866


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 876


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';

Line: 1002


    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 1007


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 1011


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 1018


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 1023


    SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
      and resource_type = 'RS_RESOURCE';

Line: 1054


  CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
  WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

Line: 1058


    SELECT PREFERENCE_VALUE
	FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 1096


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 1107


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 1130


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id =  P_RESOURCE_ID
    AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 1138


   select count(1) into l_group_check
   from ar_collectors where status='A' and
   nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';

Line: 1147


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND iea.alt_employee_id = :PERSON_ID  '||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL  select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND hp.cust_account_id = -1  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1176


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND hp.cust_account_id = -1  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1198


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1234


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1261


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 1268


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 1278


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';

Line: 1384


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1414


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1436


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID ' ||
          ' AND TRUNC(iea.START_DATE) <=  TRUNC(SYSDATE)  ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  ac.employee_id = :PERSON_ID  '||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1472


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND  ac.employee_id = :PERSON_ID  '||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1499


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 1506


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 1516


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';

Line: 1645


    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 1650


    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');

Line: 1654


    SELECT meaning
    FROM fnd_lookup_values
    WHERE lookup_type = in_lookup_type
    AND lookup_code = in_lookup_code
    AND LANGUAGE = userenv('LANG');

Line: 1661


    SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
    FROM ieu_uwq_sel_enumerators
    WHERE sel_enum_id = in_sel_enum_id;

Line: 1666


    SELECT collector_id from AR_COLLECTORS where resource_id = p_resource_id
      and resource_type = 'RS_RESOURCE';

Line: 1698


  CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
    WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';

Line: 1702


    SELECT PREFERENCE_VALUE
	FROM IEX_APP_PREFERENCES_B
    WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';

Line: 1747


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 1758


          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp, ' ||
	  ' JTF_RS_GROUPS_DENORM jrg ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
	  ' AND jtgrp.group_id = jrg.group_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ) ';

Line: 1777


   SELECT count(*) INTO l_check FROM iex_assignments where
   alt_resource_id =  p_RESOURCE_ID
   AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
   AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
   --Bug4646657 . Check for Deleted flag .Fixed by lkkumar. Start.
   AND NVL(DELETED_FLAG,'N') = 'N';

Line: 1785


   select count(1) into l_group_check
   from ar_collectors where status='A' and
   nvl(inactive_date,sysdate)>=sysdate and resource_type='RS_GROUP';

Line: 1795


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <=  TRUNC(SYSDATE)  ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' '||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1824


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1845


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE)  ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' '||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1880


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1905


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE)  ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1937


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 1960


	--l_security_where := ' :person_id = :person_id and collector_resource_id in (select :COLLECTOR_RESOURCE_ID from dual ';

Line: 1961


	l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 1967


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';

Line: 1977


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';

Line: 2088


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2117


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND hp.cust_account_id = -1 ' ||
          ' AND  ac.employee_id = :PERSON_ID ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND hp.cust_account_id = -1   ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2138


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND hp.site_use_id is NULL '||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2171


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.cust_account_id = hp.cust_account_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2194


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_id = iea.resource_id ' ||
          ' AND  iea.alt_employee_id = :PERSON_ID  ' ||
          ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
          ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
  	  ' AND NVL(IEA.DELETED_FLAG,''N'') = ''N'' ' ||
          ' UNION ALL select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2227


          'party_id in (select hp.party_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND  ac.employee_id = :PERSON_ID  ' ||
          ' AND ac.resource_type = ''RS_RESOURCE'' ' ||
          ' UNION ALL  SELECT hp.party_id ' ||
          ' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_ID = jtgrp.group_id ' ||
          ' AND ' || l_view_name ||
          '.site_use_id = hp.site_use_id ' ||
          ' AND ac.resource_type = ''RS_GROUP'' ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID  ';

Line: 2252


        l_security_where := ' :person_id = :person_id and collector_resource_id in (select resource_id from ar_collectors where resource_type = ''RS_RESOURCE'' and resource_id = :COLLECTOR_RESOURCE_ID ';

Line: 2259


	l_security_where := l_security_where || ' union all SELECT ac.resource_id FROM iex_assignments iea,ar_collectors ac where '||
    	                    ' iea.alt_employee_id = :PERSON_ID '||
			    ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
			    ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
                            ' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' '||
                            ' and ac.resource_id=iea.resource_id '||
                            ' and ac.resource_type in (''RS_RESOURCE'',''RS_GROUP'') ';  --Bug#5691908 replaced RS_EMPLOYEE with RS_RESOURCE by schekuri 02-Feb-2007

Line: 2269


        l_security_where := l_security_where || ' union all SELECT ac.resource_ID '||
			    ' FROM ar_collectors ac , jtf_rs_group_members jtgrp '||
			    ' WHERE ac.resource_ID = jtgrp.group_id '||
			    ' AND ac.resource_type = ''RS_GROUP'''||
			    ' AND NVL(jtgrp.delete_flag,''N'') = ''N'''||
			    ' AND jtgrp.resource_ID = :COLLECTOR_RESOURCE_ID ';