DBA Data[Home] [Help]

APPS.OE_VALUE_TO_ID dependencies on OE_PAYMENT_TYPES_TL

Line 3597: FROM OE_PAYMENT_TYPES_TL

3593: IF l_org_id is not null then
3594:
3595: SELECT PAYMENT_TYPE_CODE
3596: INTO l_code
3597: FROM OE_PAYMENT_TYPES_TL
3598: WHERE ORG_ID = l_org_id
3599: AND LANGUAGE = USERENV('LANG')
3600: AND NAME = p_payment_type;
3601:

Line 3606: FROM OE_PAYMENT_TYPES_TL

3602: Else
3603:
3604: SELECT PAYMENT_TYPE_CODE
3605: INTO l_code
3606: FROM OE_PAYMENT_TYPES_TL
3607: WHERE NAME = p_payment_type
3608: AND LANGUAGE = USERENV('LANG')
3609: AND ORG_ID is null;
3610: