APPS.QP_ID_TO_VALUE SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;

Line: 433

     SELECT  MEANING
     INTO    l_list_type
     FROM    QP_LOOKUPS
     WHERE   LOOKUP_CODE = p_list_type_code
     AND     LOOKUP_TYPE = 'LIST_TYPE_CODE';

Line: 677

	  select name
	  into l_generate_using_formula
	  from qp_price_formulas_vl
	  where price_formula_id = p_generate_using_formula_id;

Line: 878

	  select meaning
	  into  l_list_line_type
	  from qp_lookups
	  where lookup_code = p_list_line_type_code
	  and lookup_type = 'LIST_LINE_TYPE_CODE';

Line: 1179

          select meaning
	  into  l_price_break_type
	  from qp_lookups
	  where lookup_code = p_price_break_type_code
	  and lookup_type = 'PRICE_BREAK_TYPE_CODE';

Line: 1233

	  select name
	  into l_price_by_formula
	  from qp_price_formulas_vl
	  where price_formula_id = p_price_by_formula_id;

Line: 1728

         SELECT  name
         INTO    l_created_from_rule
         FROM    QP_QUALIFIER_RULES
         WHERE   qualifier_rule_id = p_created_from_rule_id;

Line: 2320

        SELECT  MEANING
        INTO    l_price_formula_line_type
        FROM    QP_LOOKUPS
        WHERE   LOOKUP_CODE = p_formula_line_type_code
	   AND     LOOKUP_TYPE = 'PRICE_FORMULA_LINE_TYPE_CODE';

Line: 2417

	   select meaning
	   into l_arithmetic_operator
	   from qp_lookups
	   where lookup_code = p_arithmetic_operator
	   and lookup_type = 'ARITHMETIC_OPERATOR';

Line: 2517

        SELECT  NAME
        INTO    l_accounting_rule
        FROM    OE_RA_RULES_V
        WHERE   RULE_ID = p_accounting_rule_id;

Line: 2618

        SELECT  MEANING
        INTO    l_freight_terms
        FROM    QP_LOOKUPS
        WHERE   LOOKUP_CODE = p_freight_terms_code
        AND     LOOKUP_TYPE = 'FREIGHT_TERMS';

Line: 2667

        SELECT  NAME
        INTO    l_invoice_to_contact
        FROM    OE_CONTACTS_V
        WHERE   CONTACT_ID = p_invoice_to_contact_id;

Line: 2716

        SELECT  NAME
        INTO    l_invoicing_rule
        FROM    OE_RA_RULES_V
        WHERE   RULE_ID = p_invoicing_rule_id;

Line: 2766

        SELECT  NAME
        INTO    l_payment_term
        FROM    OE_RA_TERMS_V
        WHERE   TERM_ID = p_payment_term_id;

Line: 2814

        SELECT  NAME
        INTO    l_price_list
        FROM    qp_list_headers_vl
        WHERE   list_header_id = p_price_list_id and
			list_type_code='PRL';

Line: 2861

       select name
       from ra_salesreps
       where salesrep_id = p_salesrep_id;

Line: 3270

          SELECT  meaning
          INTO    l_ship_method
          FROM    oe_ship_methods_v
          WHERE   lookup_code = p_ship_method_code;

Line: 3321

          SELECT  meaning
          INTO    l_agreement_source
          FROM    qp_lookups
          WHERE   lookup_code = p_agreement_source_code
          AND     lookup_type = 'AGREEMENT_SOURCE_CODE';