DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on HZ_PARTIES

Line 3641: FROM hz_parties hp, fnd_lookup_values fl, fnd_languages fndl -- 16084377 AME BSA

3637: BEGIN
3638:
3639: SELECT category_code
3640: INTO l_cust_category
3641: FROM hz_parties hp, fnd_lookup_values fl, fnd_languages fndl -- 16084377 AME BSA
3642: WHERE fl.lookup_type = 'CUSTOMER_CATEGORY'
3643: AND fl.LANGUAGE = fndl.language_code
3644: AND fndl.installed_flag = 'B'
3645: AND fl.lookup_code = hp.category_code

Line 3659: FROM hz_parties hp, fnd_lookup_values fl, fnd_languages fndl

3655:
3656: BEGIN
3657: SELECT category_code
3658: INTO l_cust_category
3659: FROM hz_parties hp, fnd_lookup_values fl, fnd_languages fndl
3660: WHERE fl.lookup_type = 'CUSTOMER_CATEGORY'
3661: AND fl.LANGUAGE = fndl.language_code
3662: AND fndl.installed_flag = 'B'
3663: AND fl.lookup_code = hp.category_code