DBA Data[Home] [Help]

APPS.ZX_DETERMINING_FACTORS_PKG dependencies on HZ_GEOGRAPHY_TYPES_VL

Line 479: SELECT GEOGRAPHY_TYPE_NAME INTO L_DET_FACTOR_NAME FROM HZ_GEOGRAPHY_TYPES_VL

475: IF (C%NOTFOUND) THEN
476: BEGIN
477: SELECT Zx_Determining_Factors_B_S.nextval INTO L_DETERMINING_FACTOR_ID FROM DUAL;
478: /*Get the DETERMINING_FACTOR_NAME from HZ_GEOGRAPHIES for DETERMINING_FACTOR_CODE*/
479: SELECT GEOGRAPHY_TYPE_NAME INTO L_DET_FACTOR_NAME FROM HZ_GEOGRAPHY_TYPES_VL
480: WHERE GEOGRAPHY_TYPE = X_DETERMINING_FACTOR_CODE
481: AND GEOGRAPHY_USE= (DECODE(X_DETERMINING_FACTOR_CLASS_COD, 'GEOGRAPHY', 'MASTER_REF', 'TAX'))
482: AND ROWNUM = 1;
483: EXCEPTION