DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_RET_COST_TYPE dependencies on PA_LOOKUPS

Line 34: FROM pa_lookups

30:
31: --Determine if the current Expenditure Type occurs in the POS Exp Types Lookup Set
32: SELECT COUNT(*)
33: INTO v_count
34: FROM pa_lookups
35: WHERE lookup_type = 'PROCEEDS_OF_SALE_EXP_TYPES'
36: AND lookup_code = upper(p_expenditure_type); -- Adding upper() for Bug3290556
37: /* AND lookup_code = p_expenditure_type;*/ -- Commenting out for Bug3290556
38: