APPS.IEX_UWQ_STRAT_ENUMS_PVT SQL Statements

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

Line: 27

    select source_id
    from jtf_rs_resource_extns
    where resource_id = p_resource_id;

Line: 32

    select lookup_code, meaning from fnd_lookup_values
    where lookup_type = 'IEX_UWQ_NODE_STATUS'
    and lookup_code in ('ACTIVE', 'PENDING')  -- added by jypark 01/02/2003 not show 'COMPLETE' node
    and LANGUAGE = userenv('LANG');

Line: 38

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

Line: 45

    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: 75

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

Line: 83

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

Line: 99

     '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: 101

  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: 195

  l_str_bkr :=  ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.party_id) ' ;

Line: 197

  l_str_bkr_2  := ' 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) ' ;

Line: 201

   	        ' IN  (select iea.alt_resource_id '||
                ' FROM  iex_assignments iea ' ||
                ' WHERE  nvl(iea.deleted_flag,''N'') = ''N'' ' ||
                ' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
                ' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >=  TRUNC(SYSDATE) ' ||
		' AND iea.resource_id =  ' ||  l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;

Line: 208

  l_restrict_assign_resource := ' select iea.alt_resource_id '||
          ' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
          ' iex_assignments iea ' ||
          ' WHERE hp.collector_id = ac.collector_id ' ||
          ' AND ac.resource_id = iea.alt_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 ac.resource_id IS NOT NULL ';

Line: 220

  l_restrict_res_grp := ' select ac.resource_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 ac.resource_id IS NOT NULL  ' ||
          ' UNION ALL  SELECT jtgrp.resource_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 ac.resource_id IS NOT NULL ' ||
          ' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
	  ' AND jtgrp.resource_id = :RESOURCE_ID ' ||
	  ' AND ' || l_sel_enum_rec.work_q_view_for_primary_node  ||
          '.resource_id = :RESOURCE_ID ' ||
          ' AND jtgrp.PERSON_ID = :PERSON_ID ';

Line: 250

    l_str_bkr := ' 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) ' ;

Line: 252

    l_str_bkr :=  ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.party_id) ' ;

Line: 258

	   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: 267

	--	l_restrict_assign_resource := l_restrict_assign_resource || ' and resource_id in (select resource_id from ar_collectors where '
	--				      || ' resource_type = ''RS_RESOURCE'' and resource_id = :RESOURCE_ID ';

Line: 269

	        l_restrict_assign_resource := ' and resource_id in (select :RESOURCE_ID+0 from dual ';  --Added for bug#7499019 by PNAVEENK

Line: 349

                            ' union all (SELECT iea.resource_id FROM iex_assignments iea 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'' ))';