APPS.BIL_TX_UTIL_RPT_PKG SQL Statements

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

Line: 89

  l_update_date          VARCHAR2(100);

Line: 578

     SELECT RESOURCE_ID
       INTO  l_resource_id
       FROM JTF_RS_RESOURCE_EXTNS
       WHERE user_id = fnd_global.user_id ;

Line: 593

      SELECT  jrgm.group_id  into l_sg_id
       FROM   jtf_rs_group_members jrgm,
              jtf_rs_group_usages jrup
      WHERE   jrgm.RESOURCE_ID = l_resource_id
        AND   jrgm.delete_flag = 'N'
        AND   jrup.group_id=jrgm.group_id
        AND   jrup.usage='SALES'
        and rownum < 2  ;

Line: 637

     SELECT  to_number(to_char(a.category_id) ||'.'|| '001')
       INTO l_prod_cat_id
       FROM ENI_DENORM_HRCHY_PARENTS a
      WHERE a.OBJECT_TYPE = 'CATEGORY_SET'
        AND a.LANGUAGE = USERENV('LANG')
        AND ROWNUM < 2;

Line: 680

    SELECT attribute_code FROM AK_REGION_ITEMS
    WHERE REGION_CODE = pRegionName
    AND (ATTRIBUTE3 LIKE 'SI_MEASURE%' OR ATTRIBUTE1 ='GRAND_TOTAL' or ATTRIBUTE1 = 'DRILL ACROSS URL')
    AND NVL(ATTRIBUTE3, 'NV') NOT LIKE '"%"'
    ORDER BY DISPLAY_SEQUENCE;

Line: 687

    temp_sql:= 'SELECT null viewby';

Line: 830

  SELECT period_name INTO l_period_name
 		FROM gl_periods
 		WHERE period_type = FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE')
 		AND period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
 		AND trunc(sysdate) >= start_date and trunc(sysdate) <=  end_date;

Line: 952

	SELECT start_date
	INTO l_from_date
	FROM gl_periods
	WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
	AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
	AND ADD_MONTHS(end_date, 6)
	AND ADJUSTMENT_PERIOD_FLAG = 'N'
	AND period_name = p_from_period_name;

Line: 962

     SELECT start_date into l_from_date
       FROM BIL_TX_PERIOD_NAME_V
       WHERE value  =  p_from_period_name;

Line: 999

     SELECT end_date
     INTO l_to_date
     FROM BIL_TX_PERIOD_NAME_V
     WHERE value  =  p_to_period_name;

Line: 1004

        SELECT end_date
        INTO l_to_date
        FROM gl_periods
        WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
        AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
        AND ADD_MONTHS(end_date, 6)
        AND ADJUSTMENT_PERIOD_FLAG = 'N'
        AND period_name = p_to_period_name;

Line: 1039

PROCEDURE PARSE_MULTI_SELECT(p_multi_select_string IN OUT NOCOPY VARCHAR,
                             p_single_select_flag     OUT NOCOPY VARCHAR)
IS

BEGIN
	 p_multi_select_string :=  REPLACE (p_multi_select_string, '''','');

Line: 1046

   IF INSTR(p_multi_select_string,',') > 0  THEN
	    p_single_select_flag := 'M';

Line: 1048

	   -- p_multi_select_string :=  '( '||p_multi_select_string || ' )';

Line: 1049

	   p_multi_select_string :=  p_multi_select_string;

Line: 1051

	    p_single_select_flag := 'S';

Line: 1052

	    p_multi_select_string := p_multi_select_string;

Line: 1056

END PARSE_MULTI_SELECT;

Line: 1062

   select RESOURCE_ID
     into l_resource_id  from JTF_RS_RESOURCE_EXTNS
     where user_id = fnd_global.user_id ;

Line: 1103

                 	INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);

Line: 1107

		 	INSERT INTO  BIL_TX_PROD_TMP(ATTR4) VALUES (single_status);

Line: 1110

         	INSERT INTO  BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);

Line: 1115

          OPEN l_status_c  FOR 'SELECT ast.meaning
                                FROM as_statuses_b asb, as_statuses_tl ast, BIL_TX_PROD_TMP B
                                WHERE asb.status_code = B.ATTR4
                                AND  asb.status_code = ast.status_code
                                AND ast.language= userenv(''LANG'')
                                AND asb.enabled_flag = ''Y''
                                AND asb.opp_flag = ''Y''
                                ORDER BY ast.meaning ' ;

Line: 1130

 		-- insert into x1 values ('asn_Table(CNT).key = '|| asn_Table(CNT).key||' '||'asn_Table(CNT).value ='||asn_Table(CNT).value,sysdate); commit;

Line: 1135

        OPEN l_status_c  FOR 'SELECT ast.meaning
                              FROM as_statuses_b asb, as_statuses_tl ast
                              WHERE asb.status_code = ast.status_code
                              AND ast.language= userenv(''LANG'')
                              AND asb.enabled_flag = ''Y''
                              AND asb.opp_flag = ''Y''
                              ORDER BY  ast.meaning ' ;

Line: 1149

 		-- insert into x1 values ('asn_Table(CNT).key = '|| asn_Table(CNT).key||' '||'asn_Table(CNT).value ='||asn_Table(CNT).value,sysdate); commit;

Line: 1166

	SELECT start_Date
	INTO l_start_date
	FROM BIL_TX_PERIOD_NAME_V
	WHERE pTYPE=  l_default_period
	AND  trunc(sysdate) BETWEEN start_date and end_date;

Line: 1174

	SELECT start_date
	INTO l_start_date
	FROM gl_periods
	WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
	AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
	AND ADD_MONTHS(end_date, 6)
	AND ADJUSTMENT_PERIOD_FLAG = 'N'
	AND period_type =  l_default_period
	AND  trunc(sysdate) BETWEEN start_date and end_date;

Line: 1188

	SELECT id
	INTO l_default_start_period_id
	FROM BIL_TX_PERIOD_NAME_V
	WHERE pTYPE= l_default_period
	AND start_date = l_start_date;

Line: 1195

	SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
              DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
        INTO l_default_start_period_id
	FROM gl_periods
	WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
	AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
	AND ADD_MONTHS(end_date, 6)
	AND ADJUSTMENT_PERIOD_FLAG = 'N'
	AND period_type = l_default_period
	AND start_date =  l_start_date;

Line: 1247

        SELECT end_Date
        INTO l_end_date
        FROM BIL_TX_PERIOD_NAME_V
        WHERE pTYPE=  l_default_period
        AND trunc(sysdate) BETWEEN start_date and end_date;

Line: 1254

	SELECT end_date
	INTO l_end_date
	FROM gl_periods
	WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
	AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
	AND ADD_MONTHS(end_date, 6)
	AND ADJUSTMENT_PERIOD_FLAG = 'N'
	AND period_type = l_default_period
	AND trunc(sysdate) BETWEEN start_date and end_date;

Line: 1266

        SELECT id
        INTO l_default_end_period_id
        FROM BIL_TX_PERIOD_NAME_V
        WHERE pTYPE= l_default_period
        AND end_date = l_end_date;

Line: 1273

	SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
                 DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
	INTO l_default_end_period_id
	FROM gl_periods
	WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
	AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
	AND ADD_MONTHS(end_date, 6)
	AND ADJUSTMENT_PERIOD_FLAG = 'N'
	AND period_type = l_default_period
	AND end_date = l_end_date;

Line: 1321

   SELECT FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID')
       INTO l_credit_type_id
       FROM DUAL;

Line: 1357

        SELECT   asb.status_code
          FROM     as_statuses_b  asb
         WHERE   asb.enabled_flag = 'Y'
           AND     asb.opp_flag = 'Y'
	   AND win_loss_indicator||opp_open_status_flag||forecast_rollup_flag LIKE l_flgs;

Line: 1411

	SELECT TO_NUMBER(REPLACE(p_param_in,',',NULL))
	INTO l_param_in
	FROM DUAL;

Line: 1440

        SELECT TO_NUMBER(
              substr (REPLACE(p_param_in,',',NULL),1,instr(REPLACE(p_param_in,',',NULL),'-')-1)
               )
        INTO l_param_in
        FROM DUAL;

Line: 1456

        SELECT TO_NUMBER(REPLACE(p_param_in,',',NULL))
        INTO l_param_in
        FROM DUAL;