DBA Data[Home] [Help]

APPS.QP_VALUE_TO_ID SQL Statements

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

Line: 101

    FND_API.g_attr_tbl.DELETE;
Line: 1747

     SELECT  qualifier_rule_id
     INTO    l_id
     FROM    QP_QUALIFIER_RULES
     WHERE   name = p_created_from_rule;
Line: 1897

     SELECT  qualifier_rule_id
     INTO    l_id
     FROM    QP_QUALIFIER_RULES
     WHERE   name = p_qualifier_rule;
Line: 4801

      SELECT  lookup_code
      INTO    l_code
      FROM    oe_ship_methods_v
      WHERE   meaning = p_Ship_Method and
	 rownum = 1 ;
Line: 4851

    SELECT  lookup_code
    INTO    l_code
    FROM    qp_lookups
    WHERE   meaning = p_agreement_source
    AND     lookup_type = 'AGREEMENT_SOURCE_CODE';