APPS.DDR_REF_UTIL_PKG dependencies on DDR_R_ORG

Line 170: FROM DDR_R_ORG_CHAIN

166: l_return VARCHAR2(30);
167:
168: CURSOR cur_chain IS
169: SELECT 1
170: FROM DDR_R_ORG_CHAIN
171: WHERE CHAIN_CD = p_hchy_cd
172: AND EFF_TO_DT IS NULL;
173:
174: CURSOR cur_org IS

Line 176: FROM DDR_R_ORG

172: AND EFF_TO_DT IS NULL;
173:
174: CURSOR cur_org IS
175: SELECT 1
176: FROM DDR_R_ORG
177: WHERE ORG_CD = p_hchy_cd;
178:
179: CURSOR cur_area IS
180: SELECT 1

Line 181: FROM DDR_R_ORG_AREA

177: WHERE ORG_CD = p_hchy_cd;
178:
179: CURSOR cur_area IS
180: SELECT 1
181: FROM DDR_R_ORG_AREA
182: WHERE AREA_CD = p_hchy_cd
183: AND EFF_TO_DT IS NULL;
184:
185: CURSOR cur_rgn IS

Line 187: FROM DDR_R_ORG_RGN

183: AND EFF_TO_DT IS NULL;
184:
185: CURSOR cur_rgn IS
186: SELECT 1
187: FROM DDR_R_ORG_RGN
188: WHERE RGN_CD = p_hchy_cd
189: AND EFF_TO_DT IS NULL;
190:
191: CURSOR cur_dstrct IS

Line 193: FROM DDR_R_ORG_DSTRCT

189: AND EFF_TO_DT IS NULL;
190:
191: CURSOR cur_dstrct IS
192: SELECT 1
193: FROM DDR_R_ORG_DSTRCT
194: WHERE DSTRCT_CD = p_hchy_cd
195: AND EFF_TO_DT IS NULL;
196:
197: CURSOR cur_bsns_unit IS

Line 199: FROM DDR_R_ORG_BSNS_UNIT

195: AND EFF_TO_DT IS NULL;
196:
197: CURSOR cur_bsns_unit IS
198: SELECT 1
199: FROM DDR_R_ORG_BSNS_UNIT
200: WHERE BSNS_UNIT_CD = p_hchy_cd
201: AND EFF_TO_DT IS NULL;
202: Begin
203: IF p_hchy_level IS NULL OR p_hchy_cd IS NULL