DBA Data[Home] [Help]

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FND_TERRITORIES

Line 4742: --If a row is not found in fnd_territories for the passed

4738: -------------------------------------------------------------------------------
4739: --Bug 8335551
4740: --Retrieve the 2 digit territory code from the passed 3 digit
4741: --iso territory code.
4742: --If a row is not found in fnd_territories for the passed
4743: --3 digit iso territory code, then pass back the 2 digit iso territory code so
4744: --that the CCR code will behave as it does before this fix was done.
4745: FUNCTION get_territory_code(p_iso_territory_code IN VARCHAR2)
4746: RETURN varchar2 IS

Line 4757: FROM fnd_territories

4753: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,'In: '||l_module_name);
4754:
4755: SELECT territory_code
4756: INTO l_2char_territory_code
4757: FROM fnd_territories
4758: WHERE iso_territory_code = p_iso_territory_code;
4759:
4760: RETURN l_2char_territory_code;
4761: