679: p_address_lookup_type VARCHAR2
680: ,p_use_mod_addr_type VARCHAR2
681: )IS
682: SELECT DISTINCT LOOKUP_CODE , TAG
683: FROM FND_LOOKUP_VALUES
684: WHERE LOOKUP_TYPE = p_address_lookup_type
685: AND (p_use_mod_addr_type = 'N'
686: OR (p_use_mod_addr_type = 'Y' AND
687: LOOKUP_CODE IN ('MOD_ADMIN_OFFICE', 'MOD_ISSUING_OFFICE')))