DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_RET_COST_TYPE SQL Statements

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

Line: 26

    on the Task Service Type, or some other task indicator.  Customer logic may be inserted
    into the function where indicated below.

 */

    --Determine if the current Expenditure Type occurs in the POS Exp Types Lookup Set
    SELECT  COUNT(*)
    INTO    v_count
    FROM    pa_lookups
    WHERE   lookup_type = 'PROCEEDS_OF_SALE_EXP_TYPES'
      AND   lookup_code = upper(p_expenditure_type); -- Adding upper() for Bug3290556