DBA Data[Home] [Help]

APPS.ZX_DETERMINING_FACTORS_PKG dependencies on DUAL

Line 477: SELECT Zx_Determining_Factors_B_S.nextval INTO L_DETERMINING_FACTOR_ID FROM DUAL;

473: OPEN C;
474: FETCH C INTO X_ROWID;
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'))