APPS.DDR_REF_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

    select err_name into l_err_msg from ddr_l_err where err_cd = p_err_no;

Line: 24

 select param_val into p_loading_mode from ddr_l_sys_param where param_cd = 'RUN_TYP_REF';

Line: 56

	SELECT 1
	FROM   DDR_R_MFG_ITEM_CMPNY
	WHERE  MFG_CMPNY_CD = p_hchy_cd;

Line: 61

	SELECT 1
	FROM   DDR_R_MFG_ITEM_DIV
	WHERE  MFG_DIV_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 67

	SELECT 1
	FROM   DDR_R_MFG_ITEM_GRP
	WHERE  MFG_GRP_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 73

	SELECT 1
	FROM   DDR_R_MFG_ITEM_CLASS
	WHERE  MFG_CLASS_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 79

	SELECT 1
	FROM   DDR_R_MFG_ITEM_SBC
	WHERE  MFG_SBC_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 85

	SELECT 1
	FROM   DDR_R_MFG_ITEM
	WHERE  MFG_ITEM_NBR = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 91

	SELECT 1
	FROM  DDR_R_MFG_SKU_ITEM
	WHERE MFG_SKU_ITEM_NBR = p_hchy_cd
	AND   EFF_TO_DT IS NULL;

Line: 169

        SELECT 1
        FROM   DDR_R_ORG_CHAIN
        WHERE  CHAIN_CD = p_hchy_cd
        AND    EFF_TO_DT IS NULL;

Line: 175

        SELECT 1
        FROM  DDR_R_ORG
        WHERE ORG_CD = p_hchy_cd;

Line: 180

        SELECT 1
        FROM   DDR_R_ORG_AREA
        WHERE  AREA_CD = p_hchy_cd
        AND    EFF_TO_DT IS NULL;

Line: 186

        SELECT 1
        FROM   DDR_R_ORG_RGN
        WHERE  RGN_CD = p_hchy_cd
        AND    EFF_TO_DT IS NULL;

Line: 192

        SELECT 1
        FROM   DDR_R_ORG_DSTRCT
        WHERE  DSTRCT_CD = p_hchy_cd
        AND    EFF_TO_DT IS NULL;

Line: 198

        SELECT 1
        FROM   DDR_R_ORG_BSNS_UNIT
        WHERE  BSNS_UNIT_CD = p_hchy_cd
        AND    EFF_TO_DT IS NULL;

Line: 269

	SELECT 1
	FROM   DDR_R_RTL_ITEM_CMPNY
	WHERE  RTL_CMPNY_CD = p_hchy_cd;

Line: 274

	SELECT 1
	FROM   DDR_R_RTL_ITEM_DIV
	WHERE  RTL_DIV_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 280

	SELECT 1
	FROM   DDR_R_RTL_ITEM_GRP
	WHERE  RTL_GRP_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 286

 	SELECT 1
	FROM   DDR_R_RTL_ITEM_DEPT
	WHERE  RTL_DEPT_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 292

	SELECT 1
	FROM   DDR_R_RTL_ITEM_CLASS
	WHERE  RTL_CLASS_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 298

	SELECT 1
	FROM   DDR_R_RTL_ITEM_SBC
	WHERE  RTL_SBC_CD = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 304

	SELECT 1
	FROM   DDR_R_RTL_ITEM
	WHERE  RTL_ITEM_NBR = p_hchy_cd
	AND    EFF_TO_DT IS NULL;

Line: 310

	SELECT 1
	FROM  DDR_R_RTL_SKU_ITEM
	WHERE RTL_SKU_ITEM_NBR = p_hchy_cd
	AND   EFF_TO_DT IS NULL;

Line: 393

	SELECT 1
	FROM   DDR_R_BSNS_YR
	WHERE  YR_CD = p_hchy_cd;

Line: 398

	SELECT 1
	FROM   DDR_R_BSNS_QTR
	WHERE  QTR_CD = p_hchy_cd;

Line: 403

	SELECT 1
	FROM   DDR_R_BSNS_MNTH
	WHERE  MNTH_CD = p_hchy_cd;

Line: 408

 	SELECT 1
	FROM   DDR_R_BSNS_WK
	WHERE  WK_CD = p_hchy_cd;

Line: 413

	SELECT 1
	FROM   DDR_R_DAY
	WHERE  DAY_CD = p_hchy_cd;